how to put in percentages in a pivot table?

[bigdan]

I've run a pivot table like I normally do.

Is there a way to find out what percentage of total values each bucket is taking up?

In the data below the total is 30 rows of information. So in C1 I'd like to see whatever percentage 5/30 is, in C2 I'd like to see 33% (10/30). Is there a way to make this happen?


[TABLE="width: 500"]
<tbody>[TR]
[TD]0-5 KM[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5-10 KM[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10 - 15 KM[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15 - 20 KM[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MPaul100]

Try: Right-click one of the value cells, and click Show Values As - Click % of Grand Total

 

[bigdan]

oh wow!! thanks!!

 

[bigdan]

Let me piggyback with another question please.

In Col B above, if I wanted to filter for just those values that were 5, not 10, is there a way to do that? Ideally without changing the layout of the pivot table.