CODEWITHSUNDEEP
tableau-apitableau-desktop
user19485723
user19485723

Reputation:

Tableau filter where a condition is met several months in a row

I am trying to show when sales in superstore are >10000 in x months in a row. For example, I'd like to be able to show a flag for when one category has >10000 2+ months running. Ideally, it would just be a 1 for each month it gets to 2 consecutive months. I have tried a running total and using that as a filter but it's not the prettiest solution. enter image description here

Upvotes: 0

Views: 147

Answers (1)

Bernardo
Bernardo

Reputation: 3318

Use LOOKUP. This will be TRUE if the current month and the previous month are both greater than 10,000.

enter image description here

Upvotes: 1

Related Questions