SAP Knowledge Base Article - Public

1200621 - Does Dashboards Design support Excel pivot tables?


Does Dashboards Design support Excel pivot tables?


  • Xcelsius 2008
  • Dashboards Design 4.0


Dashboards Design does not support the pivot table functionality. Dashboards Design allows you to import Microsoft Excel files that have pivot table data and use that data.

For example, you can import an Excel workbook that has pivot tables and use a Table Selector component to visualize the range of cells that is the output of the pivot table. Dashboards Design can then display the output of a pivot table, however it cannot recalculate. Currently, Dashboards Design does not support the function GETPIVOTDATA.


Xcelsius, Pivot tables , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008