Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try
sum({<[Last Ship Date]={'>$()=today()'}>}[order qty])
Hi,
you could use this expression:
=Sum({$<[Last Ship Date]={">$(=Today())"}>} [order qty])
hope this helps
regards
Marco