4 Replies Latest reply: Jan 13, 2012 6:36 PM by Miguel Angel Baeyens de Arce RSS

    Max Date, by 1st Dimension, in Pivot

    Brian Garland

      This should be simple but I can't seem to get it. I need a pivot to only show the most recent invoice date, by customer. This set analysis expression doesn't do it:  =sum({$<[InvoiceDate]={'$(=Max(Invoice_Date))'}>}[Sales Cases])          

       

      latestinvoice.jpg