Straight table, 'switch' axes

[Michiel_QV_Fan]

Hi,

I have a table like this:

Week	Revenue	Costs
1	100	90
2	110	95
3	90	96

But I would like to have this:

Keyfigure	1	2	3
Revenue	100	110	90
Costs	90	95	96

So it will be a straight table with the axes switched because I don't have the fields to create a pivot. All keyfigures are independend columns in my data and I want to keep it like that to make calculations (Revenue / Costs etc.).

How I can switch the axes?

Thanks for your help

[jagan · Accepted solution]

Hi,

Use the pivot table for doing this

Please find the sample attached.

Regards,

Jagan.

[jagan]

Hi,

In the above attachment, I pivot the Rows into Columns and Columns to Rows.

Regards,

Jagan.

[Michiel_QV_Fan]

That I didn't try. Great!

[Anonymous]

Jagan,

     I was going through the app u attached, how were you able to do that, ..I mean what options to enable in the properties..

Thanks

B

[jagan]

Hi,

Use pivot table and try to drag the expression and dimensions horizontally/vertically as you required.

Regards,

Jagan.

[Anonymous]

Got it, thank you Jagan