Jump to content

Transformation Pivot: Fix columns

Kai Lattmann

Recommended Posts


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!


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...