4 Replies Latest reply: Dec 11, 2013 3:07 AM by Simon Gurney RSS

    How to get field name out of (max(sum(xxx), 1) ... Who is the biggest?



      Sorry to ask this, (i feel rather stupid that i can't work it out)...


      How do i get the field name out of:


        num(max(aggr(sum([SALES VALUE]), Period, [ITEM DESCRIPTION]), 1), '£#,##0')


      So i can make the label "[ITEM DESCRIPTION] = £100,000"


      See attached jpg.


      Thanks in advance