10 Replies Latest reply: Dec 12, 2017 3:52 PM by Kathryn Kvas RSS

    KPI Drill Down from Overall to Groups to Determine % of Revenue for Products

    Kathryn Kvas

      I am having difficulty calculating a KPI. Below is the scenario I am attempting to capture in my KPI.


      I have 50 total products. I dill down and and select 20 products (i.e. product group). I then drill down a step further to five products. I then want to get the % of revenue for those 5 products out of the 20 products I selected.

       

      This is the equation I have tried. The current equation only gives the % of revenue for the 5 products out of the total 50 products revenue.  Note, I have to select October based on other visuals.

       

      sum(revenue)/(sum({1<wMonth={October}>}total revenue))