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

0/9000