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

    Conditional Sum

    John Quintana


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




      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!