Thanks very much. It did work.
But when I move to Columns pane, it is not working.
Even sometime it work, when additional information added, it expand to all.
You can do it multiple ways...
Something like this is also possible - working example attached, suing Superstore (v9.3.5)
logical test if date is last 3 days (dates must be pre-sorted by date)
LAST() >= 0 and LAST()<3
That will return true for the last 3 days, then use that calc, to leverage your sales...
- sum = IF [last 3 days] THEN SUM([Sales]) END
- avg = IF [last 3 days] THEN AVG([Sales]) END
Hope that helps!
212020.twbx 300.7 KB
Thanks very much..
I have resolved the issue .
Thanks once again to both Mahfooj & Mark.
Shaji, out of interest, which method did you use?
1 of 1 people found this helpful
I used your solutions and used it as a filter.