Mon 22 Jan 2007, 16:42Delegate Marie said...
Marie has attended:
Excel VBA Intro Intermediate course
Pivot tables
how do i add calculation columns to a pivot table after having created one? (like percentages of total in addition to the count or sum or add in a column with a formula within the pivot table). I know there's a way - just cannot remember
Tue 23 Jan 2007, 09:25Trainer Richard said...
RE: Pivot tables
Try dragging the field you want to calculate to the Data field. Then double click on that field and change the field settings to refect the calulation you want to see.
