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.