Cumulative total

[prashantg364]

I have 2 tables

1. Target Table, 2. Achieved Table -  shown below
I linked both tables by Month columns and want to visualize cumulative totals.
X-axis I need to keep the month number from the Target table
Y axis I need to keep the cumulative total both from the Target table & Achieved table

I tried to create a visual as shown below, but from the achieved table, I need data till last month but it is showing me data till the end.

Pls suggest any way to do the same

Target Table
Month	Target Productivity	Cumulative
Jan	0.09	0.09
Feb	0.16	0.25
Mar	0.63	0.88
Apr	0.57	1.45
May	0.71	2.16
Jun	1.33	3.49
Jul	1.18	4.67
Aug	1.11	5.78
Sep	1.13	6.91
Oct	1.34	8.25
Nov	1.38	9.63
Dec	1.425	11.055

Achieved Table
Month	achieved Productivity	Cumulative
Jan	0	0
Feb	0	0
Mar	1.39	1.39
April	3.08	4.48
May	0.80	5.27

[prashantg364]

Thanks, it works

[tamerj1]

Hi @prashantg364 
Try to add a condition

IF ( NOT ISEMPTY ( 'achieved table' ), your expression )