| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% of subtotal custom calculation in a pivot table
hello everybody,
Debra Dalgleish mentions in her pivot table recipes book that although there is no % of subtotal custom calculation available in a pivot table, one can arrange fields in the row and column areas and then use % of row or % of column to show these percentages. Does anyone know how to do this? Could you provide a short example? Microsoft should think about including this option in future Excel releases, don't you think? -- Thank you! Diego |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% of subtotal custom calculation in a pivot table
Well, if you select the dividend as the data field..
right-click in the data area, select Options... show data as: % of pick your base field. Does that work for you? "Diego" wrote: hello everybody, Debra Dalgleish mentions in her pivot table recipes book that although there is no % of subtotal custom calculation available in a pivot table, one can arrange fields in the row and column areas and then use % of row or % of column to show these percentages. Does anyone know how to do this? Could you provide a short example? Microsoft should think about including this option in future Excel releases, don't you think? -- Thank you! Diego |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% of subtotal custom calculation in a pivot table
Yes, it would be nice to have this option in a pivot table. In the
meantime, if you have two fields in the row area, and set the data field to show % of Column, the result may be similar to this: Region Product Sales (% of Col) East Chair 20.00% Table 25.00% East Total 45.00% West Chair 40.00% Table 15.00% West Total 55.00% Grand Total 100.00% Each product shows as a percent of the overall total, instead of a percent of its region. If you move Region to the Column area, the products will show as a percent of the region's total: Sales (%Col) Region Product East West Grand Total Chair 44.44% 72.73% 60.00% Table 55.56% 27.27% 40.00% Grand Total 100.00% 100.00% 100.00% Diego wrote: hello everybody, Debra Dalgleish mentions in her pivot table recipes book that although there is no % of subtotal custom calculation available in a pivot table, one can arrange fields in the row and column areas and then use % of row or % of column to show these percentages. Does anyone know how to do this? Could you provide a short example? Microsoft should think about including this option in future Excel releases, don't you think? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
| subtotal - pivot table - or better function | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| Can I set my custom views on Pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
