• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 342
  • Last Modified:

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,
0
shland
Asked:
shland
1 Solution
 
NBVCCommented:
You can't optionally choose which fields to give grand totals for.  You may have to create the formula outside the PT itself.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now