| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables - Percents in subtotal
Hi,
i have data of following structu timestamp state duration 1.1.2005 12:10 A 10 1.1.2005 13:15 A 10 1.1.2005 15:35 B 20 2.2.2005 9:01 A 10 and need them sum in pivot table according days(months): 1.1.2005 A 20 50% B 20 50% Subtotal 40 100% 2.2.2005 A 10 100% Subtotal 10 100% the problem is that i can define the % only as "% of total" or "% of column". I need one day being considered as 100%. Can anyone help me out? Thanks a lot Hana |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| % of subtotal in pivot tables | Excel Worksheet Functions | |||
| Subtotal percents in pivot table | Excel Worksheet Functions | |||
| Pivot Tables: Subtotal only certain columns? | Excel Discussion (Misc queries) | |||
| pivot table percents and counts | Excel Discussion (Misc queries) | |||
| Pivot tables % of subtotal | Excel Discussion (Misc queries) | |||
Hybrid Mode
