MikeGre - thanks so much for the quick response! What's interesting about that post is that I think it allows you to add more than "x" columns at design time. So, it enables the "+" sign when normally it would get disabled after "x" columns. In this case, I only have three columns under "Values". It's because I have a "Columns" value that is the dates in a month, sometimes it is more than 70 and sometimes it is not, based on how far into "This month" we are. It is always more than 70 if I filter to past months. So, it is only at run time the number of columns expands beyond 70 and I get a little yellow icon that says
The Pivot table is limited to 70 columns.
Totals may refer to the complete data if set by the dashboard owner.
If available, you can use filters to display fewer rows and columns.
To view all your data, download the table to CSV.
(This message will be shown to your dashboard users).
I did try the script but it doesn't seem to change this particular behavior. I tried looking around in the pivot2 documentation a bit to see if there was another setting I could spot, but didn't see anything.
I wonder if anyone has just expanded the max number of columns for the entire server to be more than 70? I suppose setting that to something like 95 will cover me here and it's only 25 more than what's already there. It's still limited so that people don't do 200 columns or something wild.
If there are any other suggestions out there, please let me know.
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.
