Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have done some reading on the community, but have not seemed to find an answer that works with my data to display the last 'x' days of data.
I have been trying to make this expression work in a pivot table:
This is how my variable looks:
Any help would be greatly appreciated.
Hi,
isn't easier to do it like this?
=sum({<Date = {'$(=Date(today()-21))'}>} Amount)
HTH
André Gomes
Your vMaxDate is of the string format like MM/DD/YYYY and therefore needs to be quoted in the expression. You can see this by leaving the Expression label blank to see what gets substituted in the expression.
I recommend you try using the numeric form of the date instead. ie define vMaxDate as:
=max(DATE)
-Rob
Rob - thanks but this does not seem to work, nothing seems to be displayed in the pivot table (nothing to do with the 'Amount' field)
This is after I have changed the variable to:
Thanks
What does the expression look like after the substitution? (In the chart column heading).
-Rob