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