3643583 - Added columns / rows disappear after changing table filters in SAC Add-in

• The formula added by "Add rows/columns" disappears after changing the members in the table filter.
• This issue occurs when a new column (row) is added, and an Excel formula referencing other columns (rows) is applied.
• The disappearance of the column is observed after modifying the table filter to remove the member in the referenced columns/rows.

SAP Analytics Cloud, add-in for Microsoft Excel

1. Log in to SAC Add-in.
2. Add a table.
3. Select a cell in the table, for example, D10.
4. Add a new column to the table with the Add Rows / Columns button in the ribbon.
5. Add an Excel formula referencing other columns in the workbook, for example, =C10-D10.
6. Change the filter of the table so that the member in D10 is removed.
7. Observe that the new column added in step 3 disappears.

This is the expected behavior. Here, the member in D10 is our 'anchored member' with which the new column is created.
When the member in D10 is filtered out, the new column will also disappear. But if C10 is filtered out instead of D10, the column will still be visible as D10 is still visible. The formula will then show a REF_ERR. 

Please note the absolute cell reference is not supported. Even if the formula is =$C10-$D10, the same behavior applies.

This is the expected behavior. Please refer to the Cause and See Also sections of this KBA for details.

• Calculations in added rows and columns
• SAP Note 3310145 - Technical details on Row or Columns Calculations in SAC table
• SAP Note 3030471 - SAP Analytics Cloud table calculation shows 'REF_ERR'

variance calculation, add rows/columns, table filter, excel formula, sap analytics cloud, sac add-in, microsoft office, column disappears, table calculations, filter changes, sac add-in workbook, dynamic variance calculation, SAP Analytics Cloud, add-in for Microsoft Excel , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-TAB , Table , Problem