2 Replies Latest reply on Jun 8, 2018 5:24 AM by Christian Go

    Select ALL value in the blended table if main table Filter = (ALL)

    Christian Go

      I got two blended datasets, dataset#1 has all the metrics while dataset#2 has the target as shown below:

        

      CountryTarget
      All69.99
      Australia84.99
      China84.99
      India84.99
      Singapore84.99
      South Africa84.99

       

      The datasets are blended via country column.

      The problem is I need the target to be set to ALL (69.99) when all countries are selected.

      Unfortunately, what happens is it just average out the country targets' which is 84.99.

       

      Any ideas?