How to convert columns into rows in Webi report

[Swapnil_Rodge]

Hi All,

We have requirement to change table columns in rows in Webi report as per below. 

Current Table:

Team Name	Market PFY	Market YTD	Medical PFY	Medical YTD
Team 1	15	20	5	9
Team 2	12	14	4	8

Target Table:

Team Name	Category	PFY	YTD
Team 1	Market	15	20
Team 1	Medical	5	9
Team 2	Market	12	14
Team 2	Medical	4	8

Is there any way to achieve this in Webi report?

Thanks !

[nachtaktiv]

You need to create new variables Category, YTD and PFY with corresponding if-statements to separate the information and then you can insert them into a table independently