Skip to Content
Apr 02, 2018 at 12:46 PM

How to Permanently Disable Result Rows in Analysis for Office (AFO)

1805 Views Last edit Apr 02, 2018 at 06:32 PM 3 rev

Hi Experts

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.

Rufus Samuel