Pivot Table

[#1]

Pivot Table

hello,

I have next pivot table

Transports

Weeknr     Car    Bus   Bicycle

52           100      75        6

51           44        33        2

50           22        11        4

49          11             3      1

48

47

etc

But now i want the years at the top so i can difference them.

How do i get the Year above?

[swarup_malli]

Do you have a year field? in the app

[#3]

yes

[#4]

but when i select i get year field left

[#5]

and not on top

[swarup_malli]

I get not get you..when you say..

but when i select i get year field left

Could you attach a sample qvw file  in this thread ?

[rwunderlich · Accepted solution]

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.

-Rob