Solved

excel pivot table grand totals question

Posted on 2013-01-25
1
287 Views
Last Modified: 2013-02-05
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
Comment
Question by:shland
1 Comment
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 38819151
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now