There is a relative date filter, if you wanted to limit your data to last three months. It appears when you right-click-drag a date dimension on the filter shelf and select 'Relative date'.
Otherwise, if you want a specific layout, the best way is to mock it up (in Excel, or even just draw it and take a photo) and attach some sample data and your mock-up.
You can create a calculated field similar to the following:
if datepart('month',[Order Date])>=datepart('month', dateadd('month', -3, today())) and datepart('month',[Order Date])<=datepart('month', today())then 'show' else 'hide' end
Then, place your measure on the field with the running total. Then, place the above calculation on the columns/rows shelf. Right click where it says hide and select Hide.
Hope this helps!
Great! That's perfect!
Thanks a lot!