I have next pivot table
Weeknr Car Bus Bicycle
52 100 75 6
51 44 33 2
50 22 11 4
49 11 3 1
But now i want the years at the top so i can difference them.
How do i get the Year above?
Do you have a year field? in the app
but when i select i get year field left
and not on top
I get not get you..when you say..
Could you attach a sample qvw file in this thread ?
Add the Year field as a Dimension. Then left-mouse drag the "Year" column heading to the upper right corner of the Pivot Table -- until the blue line turns horizontal -- and drop it there.
Retrieving data ...