How to find rank based on the YTD values

Lakshmanudui — Tue, 11 Oct 2022 06:23:45 GMT

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

topic How to find rank based on the YTD values in App Development

How to find rank based on the YTD values