what should be expression / data model to merge two different calculation in single chart ?

[shekhar_analyti]

Hi All ,

what should be expression to merge two different calculation in single chart ?

I might be asking something trivial . But please help me to get a set expression with does below 

I want below two separate to be merged  

Something like 

How to get it ?

Thanks & Regards

Shekar

[shekhar_analyti]

@sunny_talwar 

Hi Sunny Bhai , in order to get above views i had made some changes with original data , and by doing so , i almost got similar structure but getting YOY calculation in the same chart with clear distinction is not happening for me .. Please suggest /help . 

Attached raw data . 

[sunny_talwar · Accepted solution]

Check attached

[shekhar_analyti]

Thank You Sunny Bhai .. 

Apart from using synthetic dimension , is there any way to solve this doing data model changes to original data . 

[sunny_talwar]

By joining the result instead of keeping them as separate tables...

[shekhar_analyti]

Sunny Bhai .. Thanks for the Reply .

What i meant to ask was that , according your solution we have to create synthetic dimension (script level)  and had to do sorting using only function (UI)  . 

But if i have to use only this - > sum(vlues)  in expression tab , rest all to be done at script level , in order to get the exact view . What should be the script ?

 Sorry , if i am trying to over complicate . 

[sunny_talwar]

This will require some scripting. Unfortunately, I don't have the time to do this right now... may be someone else can check this out.

[shekhar_analyti]

I understand . 

Many thanks for this and upcoming questions as well !