| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code for adding a '% of total' column
What code does one need to add a single column to a pivot table for '% of
total' As in the percentageOfGrandTotal, as shown here. Product MonthA MonthB MonthC prodTotal % of total prod 1 val1 val2 val3 valTotal percentageOfGrandTotal prod 2 val1 val2 val3 valTotal percentageOfGrandTotal prod 3 val1 val2 val3 valTotal percentageOfGrandTotal monthTotal valTotal valTotal valTotal grandTotal 100% Any help, clues or pointers would be much appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding function- can you hide the 0.00 in the total column | Excel Worksheet Functions | |||
| Sumproduct and adding the total time in a column | Excel Discussion (Misc queries) | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Threaded Mode
