When you pivot or filter, the current connection updates with the latest data from Anaplan.
List-formatted line items do not show as dropdown lists in the add-in.
To pivot and filter:
- Select Pivot & Filter on the Anaplan ribbon.
- On the Pivot and Filter dialog, drag and drop the dimensions between Pages, Rows, and Columns.
- You can select Filter
next to a dimension, then:
- Select Select all.
- Select the items you want to display.
- Deselect the items you want to hide.
- Select OK.
If you deselect many items, the add-in uses Excel's row deletion action to remove items. The add-in carries out row deletions in the background, but appears frozen.
If you use Excel 2010, you may experience issues with dropdown lists in the Pivot and Filter dialog. When you select a dimension to show on a page, you're unable to use the dropdown list again to select or deselect other items. If the ribbon is unresponsive, sign out, then sign in again.