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

    MAX (Total) not working


      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