calculate grand total


D

deb

I have a pivot table and want one column grand total calculated other than
just summed.

Please notice the difference in the Ratio Grand Total
I have this... Cost/Sales=Ratio
....................Sales............Cost...............Ratio
Bob ............. 3775 ........... 2448 ............. 0.65
Ben ...............4223 ........... 3034 ............ 0.72
Dan .............. 2960 ........... 1868 ............ 0.63
Grand Total.. 10958 ........... 7350 ............ 2.0

I want...The Ratio grand total to also be Grand Total Cost/Grand Total
Sales=Grand Total Ratio

....................Sales............Cost...............Ratio
Bob ............. 3775 ........... 2448 ............. 0.65
Ben ...............4223 ........... 3034 ............ 0.72
Dan .............. 2960 ........... 1868 ............ 0.63
Grand Total.. 10958 ........... 7350 ............ 0.67
 
Ad

Advertisements

L

Luke M

I'm not sure what is causing your problem, but here's what I did. I set up a
pivot table with both a Sales and Cost column. Turned off Grand Total for
rows. I then created a calculated field with a formula of
=Sales/Cost

And my "grand total" ratio is calculated like you want, as a ratio of total,
not total of ratios.
 
Ad

Advertisements

S

Shane Devenshire

Hi,

Your problem is that you have a data column call Ratio in the data source
and the pivot table is summing that column.

The calculated field is the appropriate solution here - choose PivotTable,
Formulas, Calculated Field and enter the formula suggest by Luke. Or if you
are using 2007 - PivotTable Tools, Options, Formulas, Calculated Field...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top