I have an excel that provides details on Year_1, Year_2, Actual Sales, Actual Delivery and Actual Cumulative Delivery. I want to create a line graph with Year on 'X' Axis and the sum of figures for other columns plotted on Y axis.
Distinct values in Year_1 and Year_2 column are 2000, 2001, 2002, 2003
Actual Sales will be based on Year_1
Actual Delivery will be based on Year_2
Actual Cumulative Delivery will be cumulative of Actual Delivery figures for each year 'Year_2'.
I have created 3 expressions: Actual Sales, Actual Delivery and Actual Cumulative Delivery. However, I'm not sure on the formula to be used for Actual Sales which is based on Year_1 and Actual Delivery & Actual Cumulative Delivery which is on Year_2.