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
@maxtla Can you provide your expected result based on your given input?
@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.
Hi,
I just want to have the ID record again single, not double or triple....
thank your!
Hi,
like this?
Hi, just want to have single values in record ID....
Hi @maxtla
Still not 100% getting what your output should be, but, the attached keeps the right number of rows...