Change Pivot Table Section Rows to Columns

Darós

I created a pivot table with a dimension that i need to use as a Section. The result is normal, like any pivot table:

What i need to do is change these rows of years to columns, like this:

But i didn't find any setting or script to do it.
Also, i will have 6 years of value, so, i need 3 columns and 2 rows.

It's possible to do it in OBIEE 11g?

Gianni Ceresa

The tool doesn't do it out of the box.

11g is a very generic way to qualify the version, if you look online (both google and here in the forum) you will find pieces of code (JS / CSS) turning the vertical listing of sections into an horizontal one.

You want a 3x2, so you will have to add that logic in the code.

It's anyway custom code, not something provided by OBIEE, therefore it comes without any support and it's up to you to make it work.