Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
percent of total with partial items
I have two occurences of a sales field in a pivot table. One is total sales,
and the other is percent of total sales (automatically done within field settings, not calculated item). I am filtering the percent of sales to show only top 100 items (again, through field settings, advanced). But I'd like the resulting calculation to remain percent of total, not just what's shown. How/can I do this? -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate percent of a total within a cell | Excel Discussion (Misc queries) | |||
PivotTable - Percent of Current Total | Excel Discussion (Misc queries) | |||
Non Adjacent percent average total | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? | Excel Worksheet Functions | |||
Percent of total in Pivot tables | Excel Worksheet Functions |