How to use Crosstable-function

[#1]

Hello all,

Im trying to use the function Crosstable but I dont get it right. The attached picture shows my source and what im trying to acheive. It doesnt necesary need to be done with crosstable-function. (I dont want to do this in an object because I have to use it in other calculations in my script.)

All help and tips are appreciated.

BR

Cristian

[deepakk]

hi ,

Use the below code.

Crosstable(Account , Value,1)

Load

Year,

Accoun_1,

Account_2

....... from table;

[#3]

Thanks for your help Deepak but this results in three columns - Year, Account, Value. I would like one column per year -> Account, Year1, Year2, Year3, Year4, Year5.

Bt

Cristian

[deepakk]

hi,

Now in pivot table add Account and Year in dimension and Value in Expression . then right click and expand all...

Drag the year to top of the value field. You will get the required output.

[#5]

Yes, but I dont want to solve this in an object. I already have it in an object. I need to solve in my script. Is it possible?

Br

Cristian

[deepakk · Accepted solution]

hi Critian,

PFA

[#7]

Thank you! This works great!

Br

Cristian