Hi all,
I have what is probably a simple question, but searching hasn't brought up an answer.
I've got a simple pivot table that's looking at a single table that includes reforecast data for both Current and Previous runs. I've got 14 fields and about 55K records, and I want to create a Calculated Item for the Variance of Current vs Prior (Version field), arranged by year, as so:
<tbody>
</tbody>
When I try to create the Calculated Item for =Current - Prior in the Version field, I get the error:
"The item cannot be added or modified. There may not be enough memory, the maximum number of items allowed in a field may have been reached.... Simplify the PivotTable report or check the macro for errors"
This seems like about as vanilla a situation as you can have, and I've used this Calculated Item on larger files with the same structure before. Am I missing something obvious here?
I'm using regular PivotTables and not Power Pivot at this point.
Thanks for the help
I have what is probably a simple question, but searching hasn't brought up an answer.
I've got a simple pivot table that's looking at a single table that includes reforecast data for both Current and Previous runs. I've got 14 fields and about 55K records, and I want to create a Calculated Item for the Variance of Current vs Prior (Version field), arranged by year, as so:
Filters | Columns |
Company Number | Year |
Version | |
Rows | Sum Values |
Account Code | Value |
<tbody>
</tbody>
When I try to create the Calculated Item for =Current - Prior in the Version field, I get the error:
"The item cannot be added or modified. There may not be enough memory, the maximum number of items allowed in a field may have been reached.... Simplify the PivotTable report or check the macro for errors"
This seems like about as vanilla a situation as you can have, and I've used this Calculated Item on larger files with the same structure before. Am I missing something obvious here?
I'm using regular PivotTables and not Power Pivot at this point.
Thanks for the help