Hi, I have a pivot table that shows data as below. I donot have any
columns in pivot table.

Row Data Total
January --- Total no. of requests -- 10 ( I have created using
count )
Total no. of rejects -- 2 ( I have created
using count )
% of Rejects -- 20% ( I am not able to
get this 20% ) for some reason
Febru --- Total no. of requests --- 5
Total no. of rejects --- 4
% of Rejects --- 80% ( Not able to get
this )

Total Requests --- 15
Total Rejects --- 6
Total % of Rejects --- 40% ( Not able to get
this )

Below is what I am getting.

Row Data Total
January --- Total no. of requests -- 10 ( I have created using
count )
Total no. of rejects -- 33.34% ( I have
created using count )
% of Rejects -- 20%
Febru --- Total no. of requests --- 5
Total no. of rejects --- 4
% of Rejects --- 66.67%

Total Requests --- 15
Total Rejects --- 6
Total % of Rejects --- 100%

It is getting the % of total. Could you please help me get the desired
result.

Also, I need to set the graph color out of this pivot table if let's
say the % of rejects are more than 35% show the bar in red, if it is
more than 25% and less than 35% show in yellow and if it is less than
25% show them in green.

Could someone please help me resolve this. Thanks a lot in advance for
your help.