Row function as a Column Header

I have a cross-tab report where I want the following column headers:

Name 2002 2003 2004 Description

Unfortunately, the column headers are all the same, and as a result so are the totals beneath them (2004 on all of them). What I want is to have the column headers as displayed above and the appropriate measure totals beneath them.

I’m going nuts!! : :crazy_face: Anyone have any clue?


indy (BOB member since 2004-04-08)

How many data providers do you have? Are they properly linked?


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Only 1 data provider. Basically, we’re trying to move the top left quadrant in the slice and dice panel so that it appears in the middle of the column headers.


indy (BOB member since 2004-04-08)

None of the quandrants can be moved. You can move what is in those quandrants, but you can’t move the quandrants.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Right, I’m not actually hoping to move the quadrant. Basically, we have want to be able to calculate the totals for a specific year on the same row.

e.g.

Name 2003 2004 Description
Athena $12 $1324 A place above and beyond.
Maliva $99 $488 Beyond the norm
Robert $0 $100 Cannot stop him

Any ideas?


indy (BOB member since 2004-04-08)

I’m still not getting it. :oops:

How about you send me the report, and I’ll take a look at it for you. :yesnod:


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Thanks for the help Michael, but I found a work-around last night. I created 2 new columns with IF statements that retrieved the information I needed.


indy (BOB member since 2004-04-08)