Elena Posted February 2, 2016 Report Share Posted February 2, 2016 Hello all, I tried to create a report with Pivot Table, I used a view table as my source of data. All were great, columns, rows, summations, formatting, and formulas. Then when I go preview the report, it tells me this "Pivot table cannot have more than 200 columns". I don't have 200 columns, actually I only have 4 columns. Can anyone please help me figure out what I was doing wrong? Any help is greatly appreciated. Elena Quote Link to comment Share on other sites More sharing options...
0 Elena Posted February 2, 2016 Author Report Share Posted February 2, 2016 I figured out what's wrong. Pivot table reporting does not like view or table sources with too many fields in them. The fields are the columns (duh!). I recreated a table source with only 4 fields, but the same 600 records and Pivot Table reporting works perfectly now. Quote Link to comment Share on other sites More sharing options...
0 Elena Posted February 3, 2016 Author Report Share Posted February 3, 2016 I would like to clarify, the field that was I putting on the column section of the Pivot table has 600 records. What's happening was, because I had this field in the column, the Pivot is essentially counting the records as columns. So, naturally it would show errors. Quote Link to comment Share on other sites More sharing options...
Question
Elena
Hello all,
I tried to create a report with Pivot Table, I used a view table as my source of data.
All were great, columns, rows, summations, formatting, and formulas.
Then when I go preview the report, it tells me this "Pivot table cannot have more than 200 columns".
I don't have 200 columns, actually I only have 4 columns.
Can anyone please help me figure out what I was doing wrong?
Any help is greatly appreciated.
Elena
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.