2 Replies Latest reply on Jul 13, 2017 8:38 PM by youthesh sagar

    Measure values needs to changed when 'ALL' is selected from the Country filter drop down

    youthesh sagar

      Hi,

       

      I have data as shown below.

       

      There are two countries in my data(IND and USA). Target column will give you target sales for each country and each products and Overall target column is target for BOTH IND and USA combined by each product.

       

       

      I have a tree map as shown below. Which shows the Sum(Sales) and Max(Target) for each country that is selected in the filter.

       

       

       

      My requirement is such that when user selects ALL from country filter. The view should display total sales of both the countries and max(Overall target) column instead of Max(Target) .

       

       

      I don't want to use Country parameter for this.

       

      Thank You