
Hi,
I'm a little stuck.
When comparing subcategory sales from December to November, I want to get a top 10 based on sales of December.
If I do a simple ranking calculation Rank(sum[sales]), I get white cells and for copiers for example it is no longer showing the value from november.
Thanks for any input!
2 respostas

Hi,
thanks!! However, when I add the product name to it and generate a parameter where people can select either sales, discount or profit. This won't work unfortunately. And preferably I would want to see the overal grant total compared to the top-10 total and how much percentage this is vs the grand total.
Thanks for thinking with me!