4 Replies Latest reply on Nov 9, 2016 4:02 PM by John Quintana

    Conditional Sum

    John Quintana

      Hi,

      I need to group 3 cities total sales into 1 when a parameter value is selected.

       

      EX:

       

      I have 3 cities, Boston, Providence, and Springfield that all have sales

       

      Boston - $100

      Providence - $200

      Springfield - $50

       

      I need to have the total - $350 - to display when "Boston" is selected in the Parameter selector.  Parameter is pulled in from the Market field in the data.

       

      I want to say IF [Parameter] = "Boston" THEN TOTAL SUM(Sales of all 3 cities)

       

      Thank you!