15 Replies Latest reply: Aug 5, 2015 9:14 AM by Rajesh V RSS

    Conditional statement in Dimension

      Hi All,

       

      I want to use the belwo IF stamnt as one of the dimension along with Name in a pivot chart.

       

      =if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<600,'0-600',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<800,'600-800',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1000,'800-1000',if((Max(TOTAL <Name> Aggr(SUM(Handled),Name,Date)))<1500,'1000-1500','1500>'))))

       

      How do i do it.

       

      It works as an expression in a Table and i want that as dimension.

       

      Or is it possible  to add it as Variable and then in to dimension