My data set has three fields: Name, Discount Rate & Week.
I want the name to populate below the week in which following conditions are met.
IF [Discount Rate]>3200 THEN [Name}
The issue is that I don't want the names to repeat in subsequent weeks if the condition has already been met.
In other words, if John Doe had a discount rate of 3300 in Week 1, and 3600 in Week 2, I only want his name to populate below Week 1.
The end result should look something like this. It seems like some sort of lookup function needs to involved.
Hope this helps.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...