2 Replies Latest reply: Oct 31, 2014 10:42 AM by Jonathan Dienst RSS

    Set Analysis to filter on a single column only

    Diwakar Nahata

      Hi,

       

      I need to write an expression which gives me Sum(Sales) and this should change only if I select Region, else it should remain the same.

      For. e.g. if there are 3 regions with sales of 100 units each, then initially without anything selected the expression should show 300, if a region is selected then it shows 100. After this, even if any more different filters are applied, it should show 100 only.

      How could this be achieved?

       

      Regards,

      Diwakar