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