RedditPP Mascot

RedditPP

r/tableau • … • u/shinnen

Exclude Dimension from Aggregate Calculation depending on Condition

Hi - hope to be able to explain this as best as I can as I cannot share the TWBX.

I'm showing a simple graph with a weekly trend of sales of a product line as a percentage of total sales for that week:

Week 10|Week 11|Week 12|Week 13 :-:|:-:|:-:|:-:| 83.5%|79.8%|81.3%|81.8%

These numbers are incorrect because (as part of the calculation of the percentage) they also include total sales for shops selling less than 3 units per week.

I would like to exclude from the percentages, the shops that sell less than 3 units of this product.

If I put a conditional filter on excluding shops that sell less than 3 units, Tableau takes this as a row total of 3 units and ignores the weekly aggregation that I am showing here.

Any help would be appreciated.

— 0