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

    Exclude filter for one dimension

    Ignas Dukynas



      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.


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




      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.