I have a matrix that overlaps several years. How do I print only the next six months of columns? i.e. September 2018 – February 2019. I am using a timeline with years, quarters and months.
In the attached model I have used a formula to calculate whether to display a certain month based on various parameters (Display Settings::).
I have then added a filter to a view (Data Matrix – Display) based on an expression (You could throw the whole calc matrix formula into the expression if you wanted to, but this way you can use the display indicator elsewhere to filter the views as necessary)
I hope this helps.