Skip to Content
avatar image
Former Member

Pivots in recurring reporte

Clients want excels with pivot tables. How do I create an automated solution where BO would create a pivot table each month (with updated data) that I don't have to touch. I know the cross tab table but it's not exactly the same thing.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 06, 2017 at 02:31 PM

    If you can not use cross tab then may be you can explore the option to use Live office.With live office embed detail report data in excel and on top of that create your pivot table.Every time you need to refresh the excel work book only.

    Add comment
    10|10000 characters needed characters exceeded