2 Replies Latest reply: Feb 19, 2013 5:07 AM by James Waller RSS

    aggr( help with returning a dimension instead of expression

      =max(aggr(count([t1Sales_Name and Cluster code]),[t1Sales_Name and Cluster code]))

      This is my code (which doesn't work...

       

      Table looks like so

       

       

      [t1Sales_Name and Cluster code]              /      Sales

      Test                                                         /      1000

      Test1                                                       /      2000

       

       

      I would like my aggr function to work out what [t1Sales_Name and Cluster code] has the highest sales value.

       

      Expected output would be

       

      Test1

       

       

       

      Let me know if I've not been clear enough,

       

      james.