I've run into an issue with a pivot table that I am at an absolute loss for. I have created a pivot table with 150 dimensions, and 10 expressions. Each dimension and expression is conditionally displayed, which allows the user to create a custom view into the data. The issue has come in when I add the 128th dimension. When I add this dimension, the expressions move from being columns to being rows. I've tested different dimensions to see if it was something about the field, but no matter what fields I use, the addition of the 128th dimension causes the pivot to move the position of the expressions. After the expression move to rows, there is no way for me to select those fields and try to move them back to the column position. I've looked through all of the documents settings and I can't see anything that would set the pivot table to work for only 127 dimensions. Is there a limit on the number of dimensions that will successfully display in a pivot? Has anyone run across this or have any idea what can be done to fix this? Any help would be fantastic. Thank you.
