1
I want to show data in a pivot table, grouped by month and year, showing items for all months, including months without data. I followed this tutorial. However, this doesn't work as I want when I additionally group by year.
Example:
2015/11/3
2016/1/7
2016/3/19
appears in the pivot table like this, if "Show items with no data" is not checked:
2015
Nov 1
2016
Jan 1
Mar 1
If it is checked, it will show:
2015
Jan 0
Feb 0
Mar 0
Apr 0
May 0
Jun 0
Jul 0
Aug 0
Sep 0
Okt 0
Nov 1
Dec 0
2016
Jan 1
Feb 0
Mar 1
Apr 0
May 0
Jun 0
Jul 0
Aug 0
Sep 0
Okt 0
Nov 0
Dec 0
What I actually want is this:
2015
Nov 1
Dec 0
2016
Jan 1
Feb 0
Mar 1
How can I do this?