How to change table format in webi?

building reports webintelligence
1

I have webi report, output is Image 1.

I want to change the table as in Image 2.

How to do it?
image2.JPG
image1.JPG

akshara20 (BOB member since 2010-12-03)

2

Hi,
I think it would be simple if you try it in a cross tab.

praveenmaddi (BOB member since 2011-05-10)

3

Changing into cross tab will have the order as well as invoice column repeating.
Later on, I am going to create a chart(horizontal stacked bar) based on this table.

akshara20 (BOB member since 2010-12-03)

4

Hi,

Create 4 variables:

var1: if outcome=“y” then “y”
var2: if outcome=“N” then “N”
var3: if (var1) = “y” then Number;
Var4: if var2=“N” then Number;

use all the variables in the report.

Thanks
Purna Mandadapu

purna.mandadapu (BOB member since 2010-09-22)