Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

How to: accumulated values in pivot table by month

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

   

Year20082008
MonthTotal
Jan1010
Feb2030
Mar3060
Apr40100
May50150
Jun60210
Jul70280
Aug80360
Sep90450
Oct100550
Nov110660
Dec120780
Total780780

           

YearMonthJanFebMarAprMayJunJulAugSepOctNovDecTotal
2008Total102030405060708090100110120780
2008 103060100150210280360450550660780780
1 Solution

Accepted Solutions
sunny_talwar

You want something like this?

Capture.PNG

Without selection

Capture.PNG

View solution in original post

2 Replies
sunny_talwar

You want something like this?

Capture.PNG

Without selection

Capture.PNG

josephinetedesc
Creator III
Creator III
Author

yes - exactly right ... thank you

Jo