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.
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.