Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pivot Table: Percentage of Subtotals?
Message
 
To
All
General information
Forum:
Microsoft Office
Category:
Excel
Title:
Pivot Table: Percentage of Subtotals?
Miscellaneous
Thread ID:
00405863
Message ID:
00405863
Views:
57
Using a pivot table is it possible to caculate percentages based on the sub-total instead of the grand total?

For example:

SalesmanA
WidgetA
WidgetB
Total SalesManA

SalesmanB
WidgetA
WidgetB
Total SalesManB

I need the Percentage of WidgetA & Widget B of the Total for each Salesman
kenweber
GCom2 Solutions
Microsoft Certified Professional

Next
Reply
Map
View

Click here to load this message in the networking platform