Pivoting on specific measures

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

Pivoting.yxmd

Tips and Tricks

Common Use Cases

Transformation

Accepted answers

Felipe_Ribeir0

Hi @AlterIT

One way of doing this

Pivoting.yxmd

All comments

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

Pivoting.xlsx

Felipe_Ribeir0

Hi @AlterIT

One way of doing this

Pivoting.yxmd

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280