PDA

View Full Version : PivotTable question



Kaizer
03-19-2007, 03:03 PM
I have Regions as Row Items and Sales as data in my PivotTable. The data is presented as % of Total (e.g. Region1 = 25%, Region2=35%, Region3=40%). Is it possible to have this % of Total to be multiplied by a constant (e.g. 1000) in the Pivot? The output should be: Region1=250, Region2=350, Region3=600.