Transformation Pivot: Fix columns

[Kai Lattmann]

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