14 Replies Latest reply: Mar 16, 2013 7:16 AM by Firas Ahmed RSS

    MAX (Total) not working

      Hi,

      I have a table of inventory items transactions, I'm trying to have a pivot table per item and other dimensions to get the unit cost per item for the last transaction done per date, but its working only for one item selected, but for all items it result with zero, following expression had been used

       

      sum(if(trasaction_date=MAX(TOTAL transaction_date),trasaction_cost,0))

       

      if someone can help on this issue, thank you

       

      Firas Ahmed