| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
% of subtotal in pivot Table
We have several complex pivot tables and are trying to get a % of the
subtotal instead of the total. We have infomation by state (the subtotal) and want to know the % of dollars by state not the % of each bucket of total of all the data. If this possible. We have tried calculated fields and nothing seems to work. Thanks for any ideas. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
| subtotal - pivot table - or better function | Excel Worksheet Functions | |||
| How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) | |||
| pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Threaded Mode
