Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have date created for each item, i want to calculte sum(kg) for each item untill his date created and after date created.exm:
item no.1, date created 01/09/14
sum kg untill 01/09/14 - 140 kg
sum kg from 01/09/14 - 120 kg
how i need to write this experssion in pivot ?
hope it's understood.
thanks'
yarin.
Can you explain in more words
Try like
Sum({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"} >} [Your Field])
Hi,
I think you require something like =aggr(sum(Kg),Date)
thanx