Russ Skinner
New Member
- Joined
- Jan 10, 2013
- Messages
- 29
Is there any easy way to add a grand total (Product A+B+C by year) to a powerpivot such as the one below which updates when measures are added/removed from product list.
Selecting 'grand total on for columns' in pivot table design menu does nothing.
The following pivot contains (3) measure Product A sales, Product B sales, Product C sales from three independent tables linked to a calendar which provides the year columns and row quarters.
Thanks,
Russ
Selecting 'grand total on for columns' in pivot table design menu does nothing.
The following pivot contains (3) measure Product A sales, Product B sales, Product C sales from three independent tables linked to a calendar which provides the year columns and row quarters.
Thanks,
Russ