K
Kenneth Tu
We're having a problem exporting the OWC PivotTable selection to Excel.
Filters on row and/or column axes are lost when exporting. This is
frustrating the users, especially considering Excel's pivot table
functionality is drastically different that the OWC pivot table list.
A message box appears just before the export occurs that says, 'Totals in
this PivotTable list do not include data that is hidden by filtering. When
you export this PivotTable list to Excel, the totals in the Excel PivotTable
report will include the hidden data, and as a result the total values in the
Excel report will be different.' When the export occurs, all filter
selections are completely lost, and the totals do not reflect the filter
selections.
How to I get the filter selection that the user made to export to Excel?
Thanks,
Ken
Filters on row and/or column axes are lost when exporting. This is
frustrating the users, especially considering Excel's pivot table
functionality is drastically different that the OWC pivot table list.
A message box appears just before the export occurs that says, 'Totals in
this PivotTable list do not include data that is hidden by filtering. When
you export this PivotTable list to Excel, the totals in the Excel PivotTable
report will include the hidden data, and as a result the total values in the
Excel report will be different.' When the export occurs, all filter
selections are completely lost, and the totals do not reflect the filter
selections.
How to I get the filter selection that the user made to export to Excel?
Thanks,
Ken