I have 3 fields in a csv file that I want to show in a cross tab. But I have 2 scenarios (one per row).
Row A scenario:
If a Market Group field = Industry and the Sales field = Expected, then I want to show X $ amount from the Dollar Value field.
Row B scenario:
If a Market Group field = SMB and the Sales field = Uncommitted, then I want to show X $ amount from the Dollar Value field.
Is there a formula that I can do (or some other way of solving these scenarios as a general filter will only show one result but not the other.
In my screenshot here, there is no filter or formula so it shows all $ amounts which is incorrect.
IF [Market Group] = 'Industry' AND the [Sales] = 'Expected' THEN [Dollar Value]
ELSEIF [Market Group] = 'SMB' AND [Sales] = 'Uncommitted' THEN [Dollar Value]
You wrote this, I just cleaned up the syntax.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...