Transformation Pivot: Fix columns?
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!