sum untill date

[Anonymous]

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.

[sujeetsingh]

Can you explain in more words

[senpradip007]

Try like

Sum({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"} >} [Your Field])

[senarath]

Hi,

I think you require something like =aggr(sum(Kg),Date)

thanx