1 Reply Latest reply on Feb 4, 2014 6:39 PM by Shawn Wallwork

    How do you create a formula where Row A and Row B return results based on different conditions

    Wai King Wong

      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.

      market group crosstab.PNG.png