Does Crystal Xcelsius support Excel pivot tables?

No, currently, Crystal Xcelsius does not allow Xcelsius-generated .SWF (Shockwave Flash) files to have pivot table functionality. Xcelsius does allow 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. Xcelsius can then display the output of a pivot table, however it cannot recalculate. Currently, Xcelsius does not support the function GETPIVOTDATA.

Alternatively if you are trying some workaround, here is a great trick from Michael Alexander, author of “Crystal Xcelsius for Dummies” on Simulating Pivot Table Functionality in Crystal Xcelsius

Comments are closed.