I to create a bar chart where on X-Axis I have quarter date written as YYYYQN (i.e. 2019Q1) Using the Dimension Limits to show first 5 and reversing the order via Sort table give the information I want to see, but it show it in wrong order - current quarter is show on the left, but should be on the right.
The last option is to get it via Expressions, currently this returns the correct data, but it has no limitation on the last 5 quarters:
The solution does decrease the amount of Quarters I see, thank you. I had a solution similar to this, but using endmonths and just having -13, but the issue with this one was, that the the sum would be wrong each month, since new values would be added to current quarter each month, but for the last quarter, each month they would reduce until it goes on to the next quarter. I hope you understood what I meant