calculate grand total
 

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
--
deb

calculate grand total
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"deb" wrote:

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
--
deb

calculate grand total
 

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...


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"deb" wrote:

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
--
deb