Skip to Content
0
Dec 02, 2011 at 09:07 PM

How to change table format in webi?

176 Views

How to change this result from webi report

Transaction    Outcome    Number
Order             Y         233
Order             N         523
Delivery          Y         124
Invoice           Y         423
Invoice           N         321

into

Transaction    Outcome(Y)    Outcome(N)  Number(Y)  Number(N)
Order             Y              N          233       523                                             
Delivery          Y                         124
Invoice           Y              N          423       321 

I have to create chart on this.

I have to add one more column to find deviation between Number(Y) and Number(N) which I can do by adding a column and using a formula, but how to I achieve the above table result.