Story report - transpose part of report from horizontal to vertical layout

[petrhonsa]

Hi,

does anybody knows, If in Story reports is feature to transpose part of table?

Example:

Lets say I have table with

user ID, Month, salary in January, salary in February in one row.

I would like to have two rows with:

user id, month, salary in January

user id, month, salary in February

Kind Regards,

Petr

[raghuramSK]

Hello Petr,

I am writing with respect to your example, I would be interested in knowing, how are you fetching data of Compensation for 2 months in a single row? Ideally, when you join Job Information > compensation information > Compensation, it will fetch data in separate rows.

So, I would need to understand more to provide confirmation on feasibility.

Thanks,

Raghu

[petrhonsa]

IMHO - What you have written me would give me data in separate rows only If there is an effective date. I am looking for an option, where I would get separate rows for each month even If the salary does not change.

[petrhonsa]

Hi,

I have copied data set Compensation, each data set has filter for one month in calendar year. I need frequency and currency for each month too.

Kind Regards,

Petr