How to Represent the CY Sales and LY Sales parallel with Month Year Dimension

[Sunilkumar3]

Hi Team,

I want Show CY Sales and LY sales parallel with Month year Dimension in the line chart. Below is the data. So how I can Represent it. 

Month_year	CY Sales	LY sale
Jan-23	10	15
Feb-23	20	25
Mar-23	30	28
Apr-23	40	41
May-22	60	50

Thanks in Advance 

Regards

Sunil Kumar

[SunilChauhan]

use a bar chart  where  

Dimesion= Month_year

and two expression:

Sum(CY Sales)

Sum(LY sale)

Month_year

CY Sales

LY sale

[Sunilkumar3]

Hi,

I want to show in Line chart with Current Month Year Dimension and CY Sale and LY sales line should be parallel. 

[SunilChauhan]

whats the issue there, you can use combo chart and use line instead of Bar