6 Replies Latest reply: Jul 6, 2017 1:39 PM by Mouna Chandra Konidhina RSS

    Problems to see percentage of participation per client and acumulate it.

    Alvaro Garcia

      Hi everyone ,

       

      I have problems to calculate  "% of participation per client"

       

      The calculation what i use is:

       

      SUM({<[Sales YTD]={1}>}[Net Sales])/SUM({<[Sales YTD]={1},[Client Name]=>}[Net Sales])

       

      If i divide the metric in two:

       

      • SUM({<[Sales YTD]={1}>}[Net Sales])

                          Show net sale year to date based in selection

       

      • SUM({<[Sales YTD]={1},[Client Name]=>}[Net Sales])

                          Show total net sale year to date ignoring selections ( In this case total net sales)

       

      But when i put this two metrics in a table with Clients, both metrics show the same number and of course if i use the firsth complete metric the result is always 1.

       

      My objective with that is obtain the "% of participation per client" acumulated.

      Acumulation.PNG

      Is this posible ?

       

      Thanks in advanced.