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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |