pivot values

[tuktuk]

hola,

in 2007 i have a worksheet that contains 2 pivto tables both with the same datasource.

in one pivot the Value seciton is the SumOfVolumn

the other pivot is SumOfVolume with the Show Values As "% of Coumn"

the problem is that the columns are Dates (in monthly total from historical to current, left to right)

is there a way to have the SumOfVolumn (Jan2011, then the "% of Column" Jan2011 next to it, THEN SumOfVolumn (Feb2011, then the "% of Column" Feb2011, ect....

thanks

T

 

[tuktuk]

actually this was pretty easy.

i was unaware you can have multiple grouping in the values section.

more specfically i added a second Volume to the values and set the values as % of Column.

DONE. thansk