XL07 Pivot How to simultaneously display both Count and Percentage

[FrankParisi]

Example below

Row 1 = Count
Row 2 = vertical %


<table border="0" cellpadding="0" cellspacing="0" width="256"><colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody><tr style="height:14.4pt" height="19"> <td style="height:14.4pt;width:48pt" height="19" width="64">
</td> <td style="width:48pt" width="64">May</td> <td style="width:48pt" width="64">June</td> <td style="width:48pt" width="64">Jul</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 1</td> <td align="right">1</td> <td align="right">3</td> <td align="right">2</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 1</td> <td class="xl63" align="right">6.3%</td> <td class="xl63" align="right">18.8%</td> <td class="xl63" align="right">13.3%</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 2</td> <td align="right">3</td> <td align="right">7</td> <td align="right">9</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 2</td> <td class="xl63" align="right">18.8%</td> <td class="xl63" align="right">43.8%</td> <td class="xl63" align="right">60.0%</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 3</td> <td align="right">12</td> <td align="right">6</td> <td align="right">4</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Car 3</td> <td class="xl63" align="right">75.0%</td> <td class="xl63" align="right">37.5%</td> <td class="xl63" align="right">26.7%</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Total</td> <td align="right">16</td> <td align="right">16</td> <td align="right">15</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">Total</td> <td class="xl63" align="right">100.0%</td> <td class="xl63" align="right">100.0%</td> <td class="xl63" align="right">100.0%</td> </tr> </tbody></table>
Any help gratefully received
Frank

 

[RoryA]

Hi,
You need to add the data field twice and choose to display one of them as percentage of column (right-click, Field Settings)

Note: I moved your question from the PowerPivot forum as that is a separate application only available for Excel 2010.

 

[FrankParisi]

Thank you very much, easy when you know how.
Apologies for posting in the wrong place, I am a newbie.

Regards
Frank

 

[RoryA]

Not a problem - just wanted to let you know why it had moved.