Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
just change it to pivot and drag columns and expressions as desired. See attcahed.
just change it to pivot and drag columns and expressions as desired. See attcahed.
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
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
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?