How to find rank based on the YTD values

[Lakshmanudui]

Hi All,

I have a Straight table in that i am having fields like Code, Code name, market , region and Sales.

I am trying to create Rank based on the Code Name.

I have created YTD field in Set analysis.

Sum({<Year={Max(Year)},Month={"<=$(=(Max(Month)))"}>}Sales) .

If i don't want to select any month, YTD values and Rank worked properly in highest values to lowest values. But If i select any month from Month filed then i am getting wrong rank and some codes are missing and sorting order is not working properly.

Can you please suggest me how to get rank based on the YTD if select any month or without select any month.

Can you please suggest me how to restrict month selection in YTD.

Thanks & Regards,

Lakshman