Filters and a formula for market share
I'm struggling to create a dynamic market share calculation. Current calc is done via ETL and is too rigid, and frankly imprecise because the calc is at a monthly level, not the timeframe in which the dashboard may be currently filtered. I really need a Beast Mode solution. The core formula is simple: X sales / all sales…
