When am using Analysis for Office, each and every time when I drop the columns, Result rows are getting generated and its obviously takes more time to display the required data when running the report for large Data sets.
I need to remove the Result rows manually after doping the columns. But is there any other way or settings to do in Excel, to permanently avoid displaying the Result rows in Analysis for office.
I am using the version - 2.4.3 Patch 2. Kindly help me to solve this.