hgeurts
asked on
Exclude field in pivot table from totals
Hi,
I have an easy question:
I have a pivot table which shows sales per customer, product group, product in quantities and amounts.
I want to show the totals for the quantities ONLY on product and product group level.
See the attachment.
The red cells must be empty.
Is this possible?
Ide
pivot.xlsx
I have an easy question:
I have a pivot table which shows sales per customer, product group, product in quantities and amounts.
I want to show the totals for the quantities ONLY on product and product group level.
See the attachment.
The red cells must be empty.
Is this possible?
Ide
pivot.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.