Thanks for the help Zheng!
Another small query - Let us say that I want to enable the filter on the X-axis (Date). Something like - last 7 days or last 30 days.
Assuming the raw data has been there for a year or so, the suggested solution takes the value pertaining to the first date passing through the filter.
Example - If I want to enable the filter on date as (after 27th November) and yet want to see the value of 11 against 28th November, how do I do that?
You can create a Date Filter that is a Table Calculation. This will have the result of hiding filtered dates from the view, but they are still counted in the calculations.
All the Date Calculation does is lookup the order date. You can see how it is created here. Its only purpose is to have a list of dates that are a Table Calculation, so that the filter will hide rather than exclude dates you choose not to show.
So here I have Quantity and Running Sum of Quantity going down Order Date. Notice that 1/9/2015's Running Sum is 58.
If we filter the Date Filter to hide previous dates, it still shows 58:
I hope this helps.
Soft Date Filter.twbx 361.0 KB