How to change Column to Row

building reports webintelligence
1

Hi,

My report is like…

Country Year
France 2004
France 2005
France 2006
US 2004
US 2005
US 2006

But I want to change like…

Contry Year Year Year
France 2004 2005 2006
US 2004 2005 2006

Can any one tell me the solution… But It should be a Vertical Table…

Awaiting ur reply.
Regards
Mahesh

mahesha (BOB member since 2011-05-11)

2

mahesha,

Welcome to B :mrgreen: B!
Have a look at this post:-
https://bobj-board.org/t/175322

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thanks for ur reply…

I need to change the structure only…

Mahesh

mahesha (BOB member since 2011-05-11)

4

Hi Mahesh,

Hope crosstab would make this…

But Cross Tab header will be based on year and you can add measure value to it to display in cell.

lnarayanan86 :india: (BOB member since 2009-08-05)

5

Thanks for ur reply…

If i Use Cross tab, Header also coming like Year names…And more over i dont want to use Crosstabs…:frowning:

Mahesh

mahesha (BOB member since 2011-05-11)

6

As BO works based on each rows fetched from DB, i hope this will not be possible or will be too complex in BO…

Even I had a similar requirement but finally we gave up and provided solution to use min & max to show atleast two values…

lnarayanan86 :india: (BOB member since 2009-08-05)

7

You may acheive this by using Rank() over function and cross tabs.

Hope this helps you.

Regards.

Rmbodvp :india: (BOB member since 2010-10-14)

8

Hi Shriram,

Thanks for ur reply,

I have more than 10 dimensions in that table , So if i change this structure to cross tab is not possible… I want to do in Verticle Table. Not in Cross tab. :hb:

Thanks
Mahesh

mahesha (BOB member since 2011-05-11)

9

Can you post the exact requirements?

Regards.

Rmbodvp :india: (BOB member since 2010-10-14)

10

Hi Shriram,

PF attahced file.

Mahesh

mahesha (BOB member since 2011-05-11)

11

You forgot to attach the file.

Rakesh_K :india: (BOB member since 2007-12-11)

12

Sorry,
Now u check
Table.doc (49.0 KB)

mahesha (BOB member since 2011-05-11)

13

Hi,

Can you also mention the queries used here?

Regards

Rmbodvp :india: (BOB member since 2010-10-14)

14

How many years do you have? You can create a variable for each year, so for 2005, create a vartiable =[year]where([year=“2005”), then repeat for all your years. Sounds like a lot, but you can use the dubplicate variable and it actually goes quite fast.

rbacon :us: (BOB member since 2011-02-03)

15

Create two separate queries and merge the dimensions.

Rakesh_K :india: (BOB member since 2007-12-11)

16

Also check this thread:

https://bobj-board.org/t/175556

There is a Universe as well as report level solution.

BO_Chief :us: (BOB member since 2004-06-06)