Pivot View 2: 'Headers influence automatic column widths'?

lowellchung · June 12, 2013 5:29AM

Hi Guys,

I am a new user at Investec and the new set of reports we want to create require multiple x-axis headers. The problem is that the later groupings are bigger and it is making the format awful.

Someone said I need to use the function "Headers influence automatic column widths", however I can't seem to find it.

Can someone please assist or point me in the direction of a work around for this?

Thanks and Regards,
Lowell

tjbate · June 13, 2013 11:35AM

Lowell - There were changes between Pivot View 1 and Pivot View 2 in version 2.8...what version are you using? From version 2.8, there is a new version but also the option to change back to the old version from:
Pivot View Toolbar: > Tools (blue spanner) > Other > View version

lowellchung · June 14, 2013 5:00AM

Hi, I am using the latest pivot as I need the multiple headers accross the X-axis. I am now looking for a way to hold the width of the columns as I would like them displayed. I am wondering whether the "Headers influence automatic column widths" is available in the 2.8 version? If not another method to do this would be great?

steve · June 17, 2013 4:03AM

I don't think the option you mention would help, and anyway is not available in the new Pivot view. We are tracking this idea here; try the workaround:
http://forums.visokio.com/discussion/2188/idea-pivot-view-2-non-uniform-rowcolumn-sizings/p1

DominicChan · July 16, 2013 6:39AM

Hi Guys

I am working with the user who raised this originally, the issue with pivot table column/row headers all are of same height/width rendering a lot of empty space.

I see you have reclassified an earlier posting (http://forums.visokio.com/discussion/2188/idea-pivot-view-2-non-uniform-rowcolumn-sizings/p1) as idea.

Any news on this? Its a very powerful pivot table but being let down by formatting issues. We are very keen to see if we can have this working?

Thanks
Dom

steve · July 24, 2013 1:49AM

For variable-size group columns/rows, please discuss here:
http://forums.visokio.com/discussion/2188/idea-pivot-view-2-non-uniform-rowcolumn-sizings/p1

This post pertains to the idea of fitting automatic column width to the axis label cells in addition to the data cells. Please post example IOK files which demonstrate specifically this requirement (as opposed to the variable-size requirement).

Welcome!

Categories

Ideas Parade

Tagged