| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table: showing data as % of subtotal
Hi,
I have pivot table data in this format: Name Type Amount ABC 1 $100 2 $200 3 $300 4 $400 ABC Total $1,000 DEF 1 $150 2 $260 3 $310 4 $420 DEF Total $1,140 and so on .... .... .... I want to see the data as follows: Name Type Amount % ABC 1 $100 10 2 $200 20 3 $300 30 4 $400 40 ABC Total $1,000 100 .... .... .... Please help me... kindly reply to my mesg personally. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing Pivot Table total on Associated Pivot Chart | Excel Discussion (Misc queries) | |||
| Subtotal in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) | |||
| % of subtotal in pivot Table | Excel Discussion (Misc queries) | |||
| display data as a percentage of a subtotal in excel pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
