Printing selected columns over years

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
145 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.

Answered question

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.

Answered question

Latest Questions

Pareto – 80/20 Rule 2 Answers | 0 Votes
Setting a cell to a fixed value 1 Answer | 0 Votes
Sum formula facing SIZE issue 2 Answers | 0 Votes
Model becomes slow 3 Answers | 0 Votes