Pivot table - There are too many records to complete this operatio

G

Guest

I have created an Excel pivot table from a SQL Server data source. The pivot
has columns showing "Actual" against "Forecast" numbers for each department.

The problem is, when I attempt to add a calculated item to show the
"Variance" which is = "Actual" - "Forecast", I get the message
" There are too many records to complete this operation".

For testing purposes I reduced the dataset to just 10 rows but still got the
same message.

Any ideas will be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - calculated item 0
Calculated Item in a Pivot Table 2
Problem with Calculated item in Pivot Table 1
'too many records to complete operation'... 1
Excel 2007 Pivot table error "There are too many records to complete this operation" 3
pivot table error:Too many records to complete this operation 3
Pivot table error- too many records 1
Pivot Calculated Field 1

Top