The attached file contains pivot table with the calculated item "Remaining +/(-)". Without the calculated item everything evaluates correctly but with the calculated item, the pivot table creates unnecessary rows. Adding a field to the pivot table further multiplies the issue. How can this be fixed?
Bookmarks