Skip to Content
avatar image
Former Member

Pivot Functionality on Excell output file

Hi:

I have many reports that I want to automate. How ever my customers require to have pivot functionality on the files that I send. For example I have a report that displays 4 different boxes in excel using pivot tables. I can mimic the pivot table in BO, the problem is when I export (output) my report as an excel file the functionality goes away. Is there any way to keep some sort of dynamic functionality once I export my files?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 02, 2017 at 07:46 PM

    No it's not possible.Once you export the report in excel then BO/Webi don't have control on the excel file.

    Instead of exporting first in the excel and doing Pivoting ask users to do analysis/filters in webi and export in excel when final output is required.

    Users can use input control or drill filters functionality for analysis.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 09:27 PM

    Hi:

    Thanks for the answer, this report is for external clients, so they don't have access to the platform.

    Thanks again.

    Add comment
    10|10000 characters needed characters exceeded