Dear Community,
I have a question about the Rank function.
I've created one table with
-dimension Product,
-the first measure is sum(MC)/sum(TS),
-the second measure is RANK(sum(MC)/sum(TS),4,1)
The problem is that I have a percentage greater than 100 %.
Can someone give me some advice on how to proceed?
Also, I have a lot of filters, which should affect this table and the results in the table.
Thank you in advance!
