Date conditional sum

[#1]

I have a series of values (order qty) and a series of dates (Last Ship Date).  I only want to add values where the date is greater than today.  I currently have this set-up in a pivot table using years and months as the groupinngs.  This is the conditional statement that I am using in the expression: [Last Ship Date]>>Today.  This is the expression: sum([order qty])

I want to do this without putting a filter on entire sheet.  Any recommendations?

[Anonymous]

try

sum({<[Last Ship Date]={'>$()=today()'}>}[order qty])

[MarcoWedel]

Hi,

you could use this expression:

=Sum({$<[Last Ship Date]={">$(=Today())"}>} [order qty])

hope this helps

regards

Marco