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

[Anonymous]

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))

[Anonymous]

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?