Hi All. I currently have a data tab with monthly data that is dropped in at the end of each month. My columns in the pivot table are months that are part of the data set. my rows are categories that are part of the data set. Is there anyway I can have FIXED rows and FIXED COLUMNS. For example; right now there is no data for the month June so there is no June column... Is there anyway to have Jan - Dec columns fixed all the time even if there is no data from the pivot table.
To simplify I just want a 12 month table even if there is no data for some months... I know I can use sumifs but I need to use a pivot table because I need slicers.
Thanks!
Bookmarks