Format Cross-Tab

building reports desktopintelligence
1

Hi,

I’m running a report in BO XIR2, DESKI.
The report is a crosstab ,with two rows and one column and a body.

The first row is the year and the second row is PAID, NON-PAID.
The structute is something like this :

     2007     2007            2008   2008           2009    2009
     PAID     NON-PAID     PAID  NON-PAID   PAID    NON-PAID

A 50 20 70 0 30 40
B 10 60 30 40 60 10

I need the output to show like this.

          2007                          2008                     2009 
     PAID     NON-PAID     PAID  NON-PAID   PAID    NON-PAID

A 50 20 70 0 30 40
B 10 60 30 40 60 10

How can i achieve this? Please help
REP_1.xls (23.0 KB)

lalitha (BOB member since 2006-05-05)

2

Apply break on year, remove break footers and select “center value across break” from Format > breaks menu
.

haider :es: (BOB member since 2005-07-18)

3

Awesome!!! Thanks a bunch!!

lalitha (BOB member since 2006-05-05)