1 Reply Latest reply: Sep 23, 2018 5:12 AM by shivesh singh RSS

    how can i exclude the selected value from the filter while calculating sum

    siddharth soam

      Hi

       

      I have a list of cities and sales corresponding to it

       

      City  Sales

      C1      10

      C2        20

      C3        30

       

      i want to make a generic expression so that if i select city c1 from filter it should give me 50 in kpi(i.e. sum of sales for alternate cities)