shland
asked on
excel pivot table grand totals question
Hi ,
I have created a pivot table with 4 fields in the values and I have selected to show grand totals only on columns so currently is showing grand total for all those 4 fields in the values.
Is there a way to only calculate grand total for 3 of those fields and give a formula for the grand total for the 4th field?
Thanks,
I have created a pivot table with 4 fields in the values and I have selected to show grand totals only on columns so currently is showing grand total for all those 4 fields in the values.
Is there a way to only calculate grand total for 3 of those fields and give a formula for the grand total for the 4th field?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.