Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you in advance for you effort
Current Pivot Set-up week 1 2 3 TOTAL SUBTOTAL % X Y X Y X Y Total X Total Y X Y A) 3 10 5 12 11 25 19 47 * B) 1 9 2 6 8 15 11 30 C) 5 11 5 11 5 11 15 33 SUBTOTAL: 45 110 D) 6 15 8 17 15 30 29 62 # TOTAL: 74 172 *I would like this percentage to have the following formula: =19/45 # This percentage should have the following formula: =29/74 How can I get this to work? Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create a calculated field from another calculated field? | Excel Discussion (Misc queries) | |||
pivottable calculated fields | Excel Discussion (Misc queries) | |||
PivotTable Calculated Item error | Excel Discussion (Misc queries) | |||
Using a MIN, MAX formula on a calculated field in a pivot table | Excel Discussion (Misc queries) | |||
PivotTable - calculated items? | Excel Discussion (Misc queries) |