Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculated Fields in Pivot Tables

Status
Not open for further replies.
comconrk

comconrk

Programmer
Joined
Jul 15, 2002
Messages
55
How can I set up Excel to allow calculated fields in pivot tables?

Thanks very much
 
Sort by date Sort by votes
Hi,
Select the cell where you want the calculation. Click Pivot Table on the Pivot Table toolbar. Point to Formulas and select Calculated Field.

Good luck,
BlueHorizon
 
Upvote 0 Downvote
Thanks very much.
That did it.
I was feeling pretty stupid!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question Question
Pivot Table Issue
Replies
6
Views
772
Andrzejek
Andrzejek
remeng
  • Locked
  • Question Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
3K
remeng
remeng
GPnew
  • Locked
  • Question Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
2K
combo
combo
arvarr
  • Locked
  • Question Question
Pivot Table - Calculated Fields / Different From
Replies
12
Views
897
combo
combo
remeng
  • Locked
  • Question Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
748
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top