Transformation Pivot: Fix columns?

Hello,

when I create a Transformation Pivot table, the pivot made colums for each month, what is in the database.

But it is possible to create colums of month, which is not in the database? I want to see the whole year in the pivot, without creating dummy rows for the missing month.

In Access you can create a fix range of columns, that will shown the whole time, not only when there is data for it.

Is there any solution for this problem?

Thanks for helping me!

Kai

 

Login