Forum Discussion

sportive92003's avatar
sportive92003
Icon for Helper II rankHelper II
2 years ago
Solved

% for each category

Hello,

I would like to distribute the % for each category of product. I did a selection for only the clients we are lost.

 

thanks!

4 Replies

  • Selva-Salimi's avatar
    Selva-Salimi
    Icon for Solution Sage rankSolution Sage
    2 years ago

    sportive92003 

     

    you should write a measure as follows:

     

    measure percentage :=

    var total = calculate (sum(diff) , all(table))  -- or you can use allselected based on what you expect

    return

    divide (diff, total)

     

    If this post helps, then I would appreciate a thumbs up  and mark it as the solution to help the other members find it more quickly. 

    • sportive92003's avatar
      sportive92003
      Icon for Helper II rankHelper II
      2 years ago

      Hello,

      DIFF is a Measure to calculate the nomber of clients this year VS last year:

       

      ([Clients uniques Lub-Carb (présent dans un ou l'autre)]-[Clients uniques (Lub-Carb) same period]). 

       

      So in your formula it doesn't work. How to fix it?