How to convert column values into new columns in SAP BO

[former_member654089]

Hi Guys,

I have data something like this:

Qtr Wk pr am
19Q4 1 30 56
19Q4 2 31 57
19Q4 3 32 58
19Q4 4 33 59
20Q4 1 30 69
20Q4 2 31 70
20Q4 3 32 71
20Q4 4 33 72

And I want something like this:

wk pr 19Q4 20Q4
1 30 56 69
2 31 57 70
3 32 58 71
4 33 59 72

Basically i want column Qtr to get converted in to columns "19Q4" and "20Q4" with values as "am"

Thanks

Suren

[denis_konovalov]

I have fixed your tags to better align with subject of your question. Please do select more careful next time.
Also, mentioning the actual product you are using and/or report type/client you're using also help community understand issue better and provide better answers.

[former_member269762]

Hi Surendra,

Assuming Qtr,Wk and Pr as dimensions with Am as measure,

you can create a crosstab and drag Wk,Pr to columns and Qtr to rows and measure as Am.

[former_member199945]

Hi,

Are you using any prompts for Quarter/Date dimensions while running this reports?