How do you create a formula where Row A and Row B return results based on different conditions
Hi there,
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.
