Morning kind folks.
A little help if you can.
I have a Pivot Table which works as it should. But I tried to make it a bit neater and I just cant get to what I want from it. I hope you have some suggestions:
The data its pivoting only covers the last 12 months. WHich is perfect. The dates are grouped by Month then Year on the Pivot Table. This works well if there are data points in each month of the last 12. However, if theres a month with nothing in it then the Pivot misses out that row. If I ask it to display all blank rows, then it adds in for the whole two years (2019/20) instead of just the blank months in the last 12. Is there a way around this?
thanks
Bookmarks