Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
Hierarchy:
1. Business (Business has many product groups)
2. Product Group (Product Group has many products)
3. Products
A work around would be creating a new dimension within the script that excludes all the products within my if(No Match() Statement. Can you give me an example of how to exclude data within a dimension in the load script?