close
I have a PivotTable with Customer, Date grouped by Year and Month. The
table has AutoFormat Report 6 applied. The Date group is set to show items
with no data. This is important and must stay that way. I use the even
spacing to create a static report with a difference line automatically added.
There are some customers that do not have data for all listed years. So
they may have information for 2004 but nothing in 2005. The table is
displaying the grouping as such:Customer 123.00
2004 123.00
Jan 123.00
Feb
2005 Jan
Feb
The year that doesn't have any data is shifting the month up into the year
row. How do I stop this from happening? Is there any way?
全站熱搜
留言列表
