Rank Error with Multiple Dimensions/Lists
I am building a module that is ranking the Cost Centers for the Corporate segment based on the amount of Expenses per Employee (USD) that it has accumulated in 2023 for the Travel & Entertainment account and the Employee Relations account separately. The time dimension includes YTD, QTD, and Month. I want the rank to adjust based on the YTD, QTD, and Month for time and also change based on the account selected.
There is an error with the Rank line item, and it is not ranking sequentially starting from 1.
This is my formula: RANK('Expense per Employee (USD)', DESCENDING, SEQUENTIAL, Segment Text = "Corporate")
Please assist on the best method to go about the RANK function. Attached is a screenshot of my module in the DEV environment. In the PROD environment, the Expense per Employee (USD) line item is populating the data accordingly so that is not an issue.