Skip to main content

Hi everyone,

 

I have a visualization than updates daily with the most sold products of the previous day + the % of total per each product.

I'm displaying only the 20 most sold products (rank by quantity)  because the list can be sometimes very long, and I would like to add a new chart indicating the % of total of those 20 products (everyday they are different), but I don't know how to do the calculation.

 

Can someone help me with this?

 

Thank you very much!

5 件の回答
  1. 2018年3月2日 9:31

    Hi Xavier,

     

    I think you just need to create a Set here.

     

    Hi Xavier, I think you just need to create a Set here.

     

    Create below calculation and drag to Text

    SUM([Units Sold]) / TOTAL(SUM([Units Sold]))*100

     

    Screen+Shot+2018-03-02+at+3.00.07+PM.png

0/9000