This is a recommended work around for the governor exceeded limit error in a pivot table you just need to edit the instanceconfig.xm & bounce the server after editing the following XML tags.
<CubeMaxRecords>40000</CubeMaxRecords>
<CubeMaxPopulatedCells>150000</CubeMaxPopulatedCells>
I’ve also seen that using excluded columns with a dummy column works too.
