Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
thank you nirmal, can you pls. advice how to upload?
pls. find attached a sample data
Hi,
This has a section access, kindly give us user name and password of user and admin
Regards,
Kaushik Solanki
admin/noaccess