Create combo chart with line series

Hi,

I'm trying to create combo chart with line series. It means that column series and line series share the same group.

If my data looks like this:

Date              Groups      Total

2015/1/3       A               10

2015/1/4       A               10

2015/4/3       A               10

2015/5/3       A               10

2015/7/3       A               10

2015/9/3       A               10

2015/11/3       A               10

2016/2/25       A               10

2016/5/25       A               10

2016/8/25       A               10

2016/10/25       A               10

2016/12/25       A               10

I just show few observations above. 

In column Date, there are mutiple date from 2015-2019.

In column Groups, there are multiple factors, such as A, B, C, D.....

In column Total, this is numeric and I just put 10 in it. But actually, there are different numbers in each row.

Now I create two measure, R and G.

So the new data looks like adding 2 new columns on it.

I use the Line and Clustered Column Chart in visualization with R as line values, G as column values, date (Year and Quarter) as x-axis, and Groups as column series.

However, there is no line series that I can also add Groups.

I found a solution here. It seems that I need to create many measures for R with different Groups.

If I have many groups in column Groups, how can I do efficiently?