don't hide column when filtering data

Hello,

I have quarterly data for several years with multiple filters. When I filter, there will be no data for some quarters and Excel hides the column for that quarter. Is there anyway to keep the column and place a 0 where the data would be? I tried the "For empty cells show:" in the PivotTable Options but this only shows a 0 if there is at least one value for that quarter. If there are no values for all rows, it will hide the column even when I have this option checked. I would like it to keep the column even when there are no values for all rows. Is it possible?

I've attached an image of an example from 2014 Q1 to 2019 Q1. I would like all the quarters in between to show with values of 0.

Capture.JPG

Thank you in advance.

I don't know what version of Excel you are using so I don't know whether or not you can utilize Power Pivot.
However if you can then the information in the first section of the linked tutorial may do what you want.
https://blog.decisivedata.net/blog/s...werpivot-model
Note that it is almost always easier for us to work with an Excel file that with a screenshot (instructions are given in the banner at the top of the page).
Let us know if you have any questions.