Sum of Products based on date

[Apache]

Hi all...

I just need to know how to calculate (sum) the product based on the date of purchase...

Eg.Tv is 40000 and next tv is need to be 80000.... like this need to add by product by upcoming....

If u need more details find the PFA..

Thank You

[David_Capan]

Hello Apache,
Try this:
rangesum(above(sum(Price),0,aggr(rowno(),Product,Date)))

[Apache]

Hi David thank you.... I just tried your code.... but its not working.....

[Apache · Accepted solution]

Thanks To all...

I just Get the answer myself which is working for this...

=Aggr(RangeSum(Above(sum(Price),0,RowNo())),Product,Date)

Regards,

Apache