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 , Dashboards and Presentation Design , Problem