Sap Hierarchy - Excel

: Select the column, click the yellow warning icon, and select Convert to Number .

: Right-click your Cross Tab > User Options . Sap Hierarchy Excel

: Use an IF statement to carry down the parent name to the child row. Formula logic: =IF(Level_Cell=0, Current_Cell, Cell_Above) 3. Analysis for Office (AFO) : Select the column, click the yellow warning

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