Ranking based on two values

[subbareddykm]

Hi All ,

I am facing one issue with raking and sorting the table with third dimension.

1:.Based on Company and Region I want rank on Age if the age is same of above value then below value should be +1 of above val.

2:Based on Company and Region I want rank on Val if the Valis same of above value then below value should be +1 of above val..

Can anyone help me here ?

[sunny_talwar]

May be check here

Continuous Ranking (no missing Rank)

[sunny_talwar]

Are you looking to get this

[subbareddykm]

Perfect Sunny,

Can you also please help me with sort ascending on Age Field also.

Thank you in advance.

[sunny_talwar · Accepted solution]

This?

[subbareddykm]

It working in this app but not working in my app 😞

[sunny_talwar]

Sorting a pivot table has always been very challenging... not sure I have a solution for your problem