This content has been marked as final. Show 2 replies
You removed the few columns which are not related to calculations and filters but the when the server doing the calculations,the combination of the total records may change because of these few columns.Check whether both the reports have the same criteria in the pivot table view properties.
mark if helpful/correct...
If the removed columns are coming for a different dimension then it would change the complete logic of the report. The best option is to analyze the physical sql's generated between 2 reports. The other reason what I can think of is removed columns might be forcing an outer join conditions and taking them out would impact the measures. Of any option the physical sql's should be able to answer that question.
Let me know if this helped.