Join 2 datasets from 2 cubes into one chart on SSRS

Question

I would like to ask, I have 2 datasets from 2 cubes, very similar data (only measure is the different), and i would like to combine both data into 1 chart.. Here is the data from the dataset:

Is there any way to combine those data into 1 chart with 2 series?

This is my goal :

Thanks for your help ! :)

Answer 1

Found the answer for this problem.. So ive tried the lookup function but it only look for one field, and i have to lookup at multi fields.. so i join them in one field like

=Sum(LookUp(Fields!xxx.Value+"-"+Fields!yyy.Value,Fields!2xxx.Value+"-"2yyy.Value,Fields!LookFor.Value,"Dataset2"))

Thanks :)