How to use Rank in Pivot

[Lakshmi Narain]

Dear All,

How to insert Rank in Pivot column. I have 3 Target. A% ,B & C%.
I want to find rank for =(A%+B+C%)/3
Can anybody help me with this. And this formula is in pivot (=(A%+B+C%)/3 ).

 

[srinidhi]

Click on the Pivot got to options<Field, Items & sets<Calculated_fields. Here enter the formula .

 

[Lakshmi Narain]

Click on the Pivot got to options<Field, Items & sets<Calculated_fields. Here enter the formula .

Hi Srinidhi,
We cant add function in it. Please check attachment of the File in that i want =(TA1%+TA2+TA3%)/3 with that average i want to take rank.

 

[srinidhi]

Please find attached the excel, I have highlighted the top5 based on the formula you have given.

 

[Lakshmi Narain]

Please find attached the excel, I have highlighted the top5 based on the formula you have given.

Sorry I am asking for Rank

 

[Somendra Misra]

Hi Lakshmi Narain,

See the file.

Regards,

 

[Lakshmi Narain]

Hi Lakshmi Narain,

See the file.

Regards,

Thanks Somendra How you did this?

 

[Somendra Misra]

Create a calculated field with a formula:
SUM of Sum of TAs
=(TA1+TA2+TA3)/3

Now you can see this. Now drag this new field again to Value region down to last added value. Right click on the this field, than select show values as. Select Rank largest to smallest.

Regards,

 

[Lakshmi Narain]

Is this option available in only 2010 above. I am using 2007 but its not there.