| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Threaded Mode
