5 Replies Latest reply: Dec 17, 2012 9:03 AM by Florian Pennetzdorfer RSS

    aggr using an 'if-dimension'

    Florian Pennetzdorfer

      Hey,

       

      I have got the following aggr-function which returns the Sales for the best Sales representative:

      max(aggr(sum(Sales),SalesRep))

       

      Now I would like to replace the dimension value with an if statement:

      max(aggr(sum(Sales),if(Variable=1,SalesRep,Region)))

       

      Obviously that expression isn't valid. Do I miss something?

       

      Regards,

      Florian