I have a data set like the below data set which has State wise Company Sales.
The requirement is to calculate the rank of Company C1 in State A,B,C in a pivot table.
The desired output is like.
|STATE||RANK OF COMPANY C1|
I am trying yo write the expression for "RANK OF COMPANY C1" in the pivot table but it didnt works.
Please help, thanks in advance.
Solved! Go to Solution.
Can you please elaborate how exactly the expression is evaluated. It produces the correct result in the sample data set but the same logic is not working properly in actual application.