Transpose and Several record IDs after transpose and cross tab

Hi,

I have a file that I have to transform with transpose and then with crosstab to make a calculation. I did my calculation and want to return the 3 dimensions again in columns with crosstab (originally columns, then transpose in rows) and then I realized that I got a recordID 3 times .(suppose are the 3 dimensions)

How to solve that? thought that with the Unique, but there is a lot of data lost. Wanted to group in column (market effects): CTR, LRMI and Steel. The rest in another column as Lever. But still having problems with the several ID records. still multipling...

do not know what to do next. any help will be more as well received.thanks

test.yxmd

Transformation

Accepted answers

All comments

binu_acs

@maxtla Can you provide your expected result based on your given input?

grazitti_sapna

@maxtla , I actually cannot understand your problem, but if you are getting dups in RecordID then you have to group data by RecordID only in cross tab while calculation.