Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago

Cumulative total

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
MonthTarget ProductivityCumulative
Jan0.090.09
Feb0.160.25
Mar0.630.88
Apr0.571.45
May0.712.16
Jun1.333.49
Jul1.184.67
Aug1.115.78
Sep1.136.91
Oct1.348.25
Nov1.389.63
Dec1.425

11.055

 

Achieved Table
Monthachieved ProductivityCumulative
Jan00
Feb00
Mar1.391.39
April3.084.48
May0.805.27