Help with PivotTable % Calculations

[jamers8]

I need help with figuring out the correct fields that should be included in the Field List to accurately display the percentage that I'm looking for.

Below is an example of the data from my pivot table. The issue I'm having is when charting this information. I am ONLY wanting to show the "GRAPES" percentage in a bar chart by month so, ultimately, in the chart it would show the 1st bar at 5.95% for Jul, 2nd bar 5.91% for Aug and so on...

The issue I'm having is when I utilize any of the filters, the percentage recalculates based off of only the "Fruit Total" that is visible whereas I still want it to be calculated off the total fruit total for the month. I've tried all the variations of recalculating found in the "Value Field Settings" > "Show values as" dialog box but haven't come up with the right combination yet. Not sure if I need to add a field somewhere so it still calculates how I am wanting...??...

Jul
FRUIT	Count of Fruit	Percentage of Fruit
APPLES	3393	93.91%
GRAPES	215	5.95%
ORANGES	4	0.11%
BANANAS	1	0.03%
Jul Total	3613	100%
Aug
FRUIT	Count of Fruit	Percentage of Fruit
APPLES	3962	94.00%
GRAPES	249	5.91%
ORANGES	3	0.07%
BANANAS	1	0.02%
Aug Total	4215	100%
Sep	Count of Fruit	Percentage of Fruit
FRUIT
APPLES	3630	94.58%
GRAPES	203	5.29%
ORANGES	4	0.10%
BANANAS	1	0.03%
Sep Total	3838	100.00%

<tbody>
</tbody>

 

[Anand Sharma]

Hi

To achieve the %age in pivot you will have to change layout of your pivot table

Row Labels	Sum of nos	Sum of nos2	Sum of nos	Sum of nos2
jan	20	33.33%	10	33.33%	30	33.33%
feb	20	33.33%	10	33.33%	30	33.33%
mar	20	33.33%	10	33.33%	30	33.33%
Grand Total	60	100.00%	30	100.00%	90	100.00%

<tbody>
</tbody>

Or other way and choose %raw in value field

For more help visit www.ExcelChat.co

 

[jamers8]

Unfortunately I'm not able to follow the example that you have given me as I'm not sure what columns you are referencing in your example and how they relate to my example.