# Help with PivotTable % Calculations

#### jamers8

##### New Member
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>

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### Anand Sharma

##### Board Regular
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

##### New Member
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.

Replies
3
Views
416
Replies
1
Views
252
Replies
1
Views
184
Replies
0
Views
218
Replies
1
Views
155

1,191,671
Messages
5,987,957
Members
440,121
Latest member
eravella

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back