Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in pivot table
I realize I may not have been too clear on my last post. But does anyone know
code that can change a grand total sum to an average total in a multiple consolidated pivot table? For example: dept comm % sales $14.15 30% HR $21.25 16% HT $36.78 1.2% $72.18 47% wrong answer(this is what I'm getting) 16% should be this one (the average of the column). When I try and do the field settings it gives me this error: Averages, standard deviation, variances are not supported when a pivot table has multiple calculated fields. So I was trying to get code for a macro that would override this error and change the to the correct totals. thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How can I get the name of the Pivot Table using Macros | Excel Programming | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |