compare Year N with Year N-1 with bar chart

[awp2020]

Hi,

I have a table like below :

ANNEE	MOIS	Production
2021	Jan	1 099
2021	Feb	976
2021	Mar	1064,08
2021	Apr	1205,45
2021	May	1187,98
2021	Jun	1138,97
2021	Jul	1117,38
2021	Aug	1182,35
2021	Sep	1028,41
2021	Oct	1106,71
2021	Nov	1105,76
2021	Dec	1085,13
2022	Jan	1117,01
2022	Feb	1062,82
2022	Mar	1228,93

II would like to display a bar graph to compare the 2 years with the months on the abscissa

To have this graph I need to have these data:

MOIS	Production N-1	Production N	YTD N-1	YTD N
Jan	1 099	1117,01	1 099	1 117
Feb	976	1062,82	2 075	2 180
Mar	1064,08	1228,93	3 139	3 409
Apr	1205,45		4 345
May	1187,98		5 533
Jun	1138,97		6 672
Jul	1117,38		7 789
Aug	1182,35		8 972
Sep	1028,41		10 000
Oct	1106,71		11 107
Nov	1105,76		12 212
Dec	1085,13		13 298

 how to get this?

Thank you for your help .

[rubenmarin]

Hi, with your initial data you can create the bars as:

• Sum({<ANNEE={$(=Max(ANNEE))}>} Production)
• Sum({<ANNEE={$(=Max(ANNEE)-1)}>} Production)

And with a combo chart you add 2 more expressions to be shown as lines, the expression would be the same but if modifiers select option to accumulate complete