Question On Pivot Table Reporting

[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

[Elena]

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.

[Elena]

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.