Rank Function w.r.t multiple dimension is not working

[abhaysingh]

Rank function is not working with multiple dimension please find the sample data as well

kindly help...........

regards

abhay

[abhaysingh]

Thanks every one its done for CY but facing problem in LY.

my PY expression is below

sum({<YEAR = , fYear={$(vPreviousYear)}>} [Pre-Tax Value]) 

please help in expression for calculating rank function of it.