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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.