6 Replies Latest reply on Jan 18, 2016 5:10 AM by Tableau kumar

    How to use aggregate filed as filter

    Shankar Mishra

      IF Sum([Amount LCY])>= 0 and Sum([Amount LCY])<=10000 THEN"0-10000"

      ELSEIF Sum([Amount LCY])>=10001 and Sum([Amount LCY]) <=30000 THEN  "10001-30000"

      ELSEIF Sum([Amount LCY]) >=30001 and Sum([Amount LCY]) <=50000 THEN  "30001-50000"

      ELSEIF Sum([Amount LCY]) >=50001 and Sum([Amount LCY]) <=100000 THEN  "50001-100000"

      ELSEIF Sum([Amount LCY]) >=100001 and Sum([Amount LCY]) <=500000 THEN  "100001-500000"

      ELSEIF Sum([Amount LCY]) >=500001 and Sum([Amount LCY]) <=1000000 THEN  "500001-100000"

      ELSEIF Sum([Amount LCY]) >=1000001 and Sum([Amount LCY]) <=5000000 THEN  "1000001-5000000"

      ELSEIF Sum([Amount LCY]) >=5000001 and Sum([Amount LCY]) <=7500000 THEN  "5000001-7500000"

      ELSEIF Sum([Amount LCY]) >=7500001 and Sum([Amount LCY]) <=10000000 THEN  "7500000-10000000"

      ELSEIF    Sum([Amount LCY]) >=10000001 AND  Sum([Amount LCY])<=100000000001  THEN "Above 1Cr"

       

       

      else "Chk"

      END

       

       

      i am trying to use this as filter but not getting the option might be because of  aggregation.