Pivot table, show data as

[marcus.brown]

Hi,

I have a pivot table, (like the below) and I wanted know how I would go about showing the data as a % of each of the columns. So, for example in the first column of the data, for int 1, it would show 93.10% (=1.25 / 1.342657...).

Doing show data as % of total, does it for the grand total, not what i'm looking for.

<TABLE style="WIDTH: 464pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=619><COLGROUP><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 2688" width=84><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3104" width=97><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3936" width=123><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3104" width=97><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 3936" width=123><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3040" width=95><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 63pt; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 height=17 width=84>Sum of SR</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 73pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 width=97>date</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 92pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl66 width=123>shift</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 73pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl66 width=97> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 92pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl66 width=123> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; WIDTH: 71pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=95> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl68 height=17> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl71 align=right>01/01/2011</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl71>01/01/2011 Total</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl71 align=right>02/01/2011</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl71>02/01/2011 Total</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl72>Grand Total</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 height=17>name</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65>m</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl68> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65>e</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl68> </TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 0.5pt solid" class=xl73> </TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 height=17>int 1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 align=right>1.25</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 align=right>1.25</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 align=right>1.111111111</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl65 align=right>1.111111111</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl74 align=right>1.176470588</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 height=17>int 2</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.527272727</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.527272727</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 0.5pt solid" class=xl75 align=right>1.514563107</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 height=17>int 3</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.276595745</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.276595745</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.2</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl69 align=right>1.2</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: black 0.5pt solid" class=xl75 align=right>1.24137931</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl70 height=17>Grand Total</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl70 align=right>1.342657343</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl70 align=right>1.342657343</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl70 align=right>1.288590604</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl70 align=right>1.288590604</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl76 align=right>1.315068493</TD></TR></TBODY></TABLE>


Thanks,