Adding Rank column as a Calculated Field in Pivot Table

[fareedexcel]

Hi Experts,

Please help in adding a rank column in pivot table. Im not sure how to bring the rank formula for each categories within the pivot table. I have attached sample excel file.

 

[shaikhrulez]

Please have a look, is this what you want?

 

[fareedexcel]

Please have a look, is this what you want?

Thank you yes this is the answer I'm looking for. But why the Rank column repeating?. It cant be shown only after the Average Total

 

[shaikhrulez]

Because I have again added Value field in Value section of Pivot Table, which resulted in showing ranking for each of the column. You may hide unwanted repeated column or copy and paste the pivot table on separate sheet and delete the extra rank columns.