I am trying to transpose a pivot table so that the weeks of the year are columns, and the years are rows but I cannot get the weeks as columns.
What I want is this:
I can get the following in the pivot
or the following
But if I add the date dimenson as a row as well as the column it doubles the values.
Any ideas please?
Please sign in to leave a comment.