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






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