Column definition

[TobiasThewes]

Hello everybody,

i try to make a dashboard with Headcount and FTE and i need to show this for every Month.

How can i define a column which adds more as one value to a same ID.

For Example i have a column:

ID

1001

1002

1003

I have to make this:

ID......l.....Period

1001..l...09.2020

1001..l...10.2020

1001..l....11.2020

1001..l....12.2020

1002..l....09.2020

So its no bad then i get a duplicate columns. PLEASE HELP 😮

[SamuelPerez]

Hi Tobias,

I'm supposing that you are using import/acquire, in this case you have the option to model on SAC,

have you tried to concatenate columns?

please check this out https://blogs.sap.com/2020/06/19/new-string-functions-in-sac-bi-calculations/