Show more than 70 columns in a pivot2 (without changing the global setting)
Hello,
We have a situation where we need to show 3 different values for each day of a month in a pivot (so, up to 93 max columns). I know there is a global setting to expand the number of columns on a pivot2 (default of 70, I assume we could go up to 93 on that, if necessary). Generally, I like the 70 column limit so I'd like this to be a one-off exception rather than increasing for everyone. In the old Windows version, there was a script out on the community that could allow more than x columns to show. Anyone have a script to do this with Pivot2 in Linux?
Thanks,
Chris
Hi cjakerle.
You can definitely change the global setting to 95. Do you have a test environment you can try it with to see what the impact may be? If not, I recommend closely monitoring the server performance after you increase the global limit to make sure the system performance is acceptable.