Move Dimensions to Top

[hschultz]

Hi all

I hope you can be of some assistance please.

We want to have a straight table (or a pivot for that matter), with calculations running down on the left, and each dimension as it's own colum.

It's best to try and explain with viewing the attached Qvw.

I know a pivot table just moves to the top, but it STILL doesn't give a line per each calculation.

I suspect there is a very simple way to this by editing the chart properties, but i cannot seem to find something like that. Otherwise how does one approach an issue like this?

Thank you all in advance.

[giakoum · Accepted solution]

just change it to pivot and drag columns and expressions as desired. See attcahed.

[hschultz]

Oh ok! Stupid mistake from my side -I see that i missed the part where i drag the calculations to the side....

This is exactly what i need, thank you

[#4]

Heinrich,

> Convert your Straight to Pivot..

> Drag your expression to the left most (relacing your Dimensions)

> Drag your dimension horizontally...

see the attached I have created one for you in the same example of yours

[hschultz]

Hi guys, this works great, but there is 1 problem:

It seems that i cannot set individual comlum widths. If i change the size to view entire Expression, it makes all the value colums bigger as well.

Is there a way to chenge each individually?