ARTBAR

raising creative thinkers

If your organization uses the add-in, you don't need to manually clean the data.

: Go to the Data tab > Get Data > From File > From Workbook/Text and select your SAP export.

SAP exports often come with "Green Triangle" errors (numbers stored as text).

: SAP hierarchies often show the same "Leaf" node under multiple "Nodes." Use Data > Remove Duplicates if you are trying to get a unique list of accounts.

: Use the "Filter by Member" settings to show only "Leaves" (the bottom-level data) if you want to avoid double-counting parent totals in your Pivot Table. 4. Common Formatting Fixes