Pivoting on specific measures

[AlterIT]

I have a dataset with few measures and I am trying to pivot the dataset only for certain measures so that final dataset will help me visualizing better. For example, below I have Sales and Profit as regular measures and at the same time I need a pivoted view of other 2 measures (Discount and Tax). I started with transpose tool and could not get much further. Any help would be appreciated , Thank you . 

I have included workflow with my source data

Desired Output

[Felipe_Ribeir0]

Hi @AlterIT 

You must attach the xlsx file

[ShankerV]

@AlterIT 

The input file is missing in the Alteryx workflow attached.

Can you please share it.

Shanker V

[AlterIT]

I have attached the file, Thank you

[Felipe_Ribeir0 · Accepted solution]

Hi @AlterIT 

One way of doing this

[AlterIT]

@Felipe_Ribeir0  Thank You !!, If we have different number of measures on both sides then we will left out with some blank rows in Pivoted fields correct ? Which I think should be ok.

[Felipe_Ribeir0]

@AlterIT  Yes! if you union L and J it would be like this. I suggest you to try some different situations considering that to change the workflow to behave as necessary on them