Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Checking the Qlikview archives - this is close to what I want but not quite:
What I want is the figures as shown below and it to be a pivot table (does not have to be a pivot table - if there is some other way of getting the months to run horizontally rather than vertically.
Thank you
Jo
Year | 2008 | 2008 |
Month | Total | |
Jan | 10 | 10 |
Feb | 20 | 30 |
Mar | 30 | 60 |
Apr | 40 | 100 |
May | 50 | 150 |
Jun | 60 | 210 |
Jul | 70 | 280 |
Aug | 80 | 360 |
Sep | 90 | 450 |
Oct | 100 | 550 |
Nov | 110 | 660 |
Dec | 120 | 780 |
Total | 780 | 780 |
Year | Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |
2008 | Total | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 780 |
2008 | 10 | 30 | 60 | 100 | 150 | 210 | 280 | 360 | 450 | 550 | 660 | 780 | 780 |
You want something like this?
Without selection
yes - exactly right ... thank you
Jo