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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Table - Percentage of a Sub Total

Status
Not open for further replies.
Tolli1

Tolli1

MIS
Joined
Nov 18, 2002
Messages
4
Location
GB
Is it possible to add a column to a pivot table which will show the values that make up a sub total as a percentage of the subtotal?
Thanks in advance!!
Tolli
 
Sort by date Sort by votes
Don't think that's possible - you can do % of total which will show them as a % of the total in that column but not % of subtotal Rgds
~Geoff~
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
3K
remeng
remeng
Cpreston
  • Locked
  • Question Question
Pivot Table Issue
Replies
6
Views
799
Andrzejek
Andrzejek
remeng
  • Locked
  • Question Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
772
remeng
remeng
BugZap13
  • Locked
  • Question Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
1K
bs6600
bs6600
E
  • Locked
  • Question Question
Extract lines from table into new table
Replies
2
Views
1K
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top