I’ve been searching around and can’t find an answer. Hoping to get some help here.
I am trying to create a dynamic precent total table calculation where the denominator stays the same but the numerator can be changed with filters in a dashboard.
For example. I want my stakeholders to be able to understand how much of revenue comes from one customer in a state of all revenue made. lets say we have $100,000 in total revenue and I want to know how much of customer A in Texas. A sample table is below to make more sense.
State | Customer | Revenue |
---|---|---|
TX | A | $50K |
CA | A | $10K |
TX | B | $20K |
NY | B | $20K |
With the scenario above I want them to be able to filter a dashboard to see the following
State | Customer | Customer Revenue | Total Revenue | % of Total Revenue |
---|---|---|---|---|
TX | A | $50K | $100K | 50% |
Basically I’m struggling with the “Total Revenue” being ignored by other filters. Ideally I would like the filter that can effect the “Total Revenue” is a date range.
Any help would be greatly appreciated!