Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ALL,
I changed existing two dimensions as columns and expressions as rows in a pivot table by using drag option. The expressions label width require more .Now the Expression labels are in First column of changed pivot table.The other columns have data require less width.
How to make different column widths like a original pivot table?Here I require more width for the First column(Expression Labels).
Thankyou
If you have 1 dimension then use straight table and select 'Horizontal' option in Presentation tab.
If you need to use a pivot table for some reason then adding a 2nd dimension (even a blank one) will allow you to change the width of the first column without the other columns following suit.
Edit - you will also need to select the 'Indent Mode' from the 'Style' properties tab.
Unfortunately all expression columns will have the same width ...
Thank you Alessandro
If you want you may mark my answer ...
If you have 1 dimension then use straight table and select 'Horizontal' option in Presentation tab.
If you need to use a pivot table for some reason then adding a 2nd dimension (even a blank one) will allow you to change the width of the first column without the other columns following suit.
Edit - you will also need to select the 'Indent Mode' from the 'Style' properties tab.
I have only one dimension which is month which transposed horizontally and measures are transposed vertically, so i am unable to change the width of dimension and measure separately.
Can you please help me out on this.