Pivot Table Calculated Item error

[Scriffer]

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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Filters[/TD]
[TD]Columns[/TD]
[/TR]
[TR]
[TD]Company Number[/TD]
[TD]Year[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Version[/TD]
[/TR]
[TR]
[TD]Rows[/TD]
[TD]Sum Values[/TD]
[/TR]
[TR]
[TD]Account Code[/TD]
[TD]Value[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[alex1alex]

Did you ever figure this out?