Printing selected columns over years

3.48K viewsTips and Techniques

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.

billy Asked question September 21, 2018

Hi Billy,
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.

You are viewing 1 out of 1 answers, click here to view all answers.

Latest Questions