2 Replies Latest reply on Nov 22, 2016 4:55 AM by Piotr Wodkiewicz

    20%,50%,80% of Business on aggregated level- Formula missing

    Piotr Wodkiewicz

      Hi,

      I would like to create a simple table for data set that has Company and Product dimension and Units and Count as a measure. In this table I want to show at the company level how many products company needs to get to 20% of their business, 50% and 80%.

       

      I have manage to do all the calcs but it works only if I have product level visible in my table. (rolling % of business) but can not figure out how to create this aggregated view where I will have count function (showing how many products is needed) .

       

      Attached I put simple xls table just to visualize what I have and what I am trying to do.

       

      Thanks in advance

      Piotr