Skip to main content

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!

 

how to rank top 10 sales of subcagetory of specific month compared to previous monthCapture2

2 件の回答
  1. 2022年10月18日 11:35

    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!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.Capture4