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?

    Simon Gurney

      Hi

       

      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

       

      Thanks

       

      Simon