How to: accumulated values in pivot table by month

[josephinetedesc]

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

[sunny_talwar · Accepted solution]

You want something like this?

Without selection

[josephinetedesc]

yes - exactly right ... thank you

Jo