6 Replies Latest reply: Sep 17, 2017 8:37 AM by Ignas Dukynas RSS

    Exclude filter for one dimension

    Ignas Dukynas

      Hello

       

      I have a real issue trying to make a comparison table between region and country sales.

       

      I get Amount (Region) numbers fine, but I struggle to get AVG(Amount) per country in the same table.

       

      For example if I select  country Belgium and Region East Flanders. Amount (Country) must disregard Region selection and show only country average.

      Capture.JPG

      I used this Set expression that does not work for me. I am also only interested in Customer John.

       

      Capture2.JPG

       

      Could anybody help me to solve this puzzle? I attach the App. !

      Would you be able to jump in @Sunny Talwar
      Thank you in advance.