Hi
I created an Export to Excel Report in which I have to generate Pivot Chart simultaneously.
Please suggest how can i do it?
Thanks
Shivendra
*This post is locked for comments
As i understood correctly, you have created the report which gives you output of your data in excel and you have some pivot created based on it. now the problem is every time your report generates new file so you need to create the pivot based on it or need to copy the data from the report the Pivot excel file.
simplest solution is too copy the data from your generated report to pivot excel table and refresh the excel sheet.
another one which is quite complex: when you export the data make provision in report to ask the file name to generate or amend existing so you can give the file name and location and also sheet name so report will overwrite the data into excel.
you can refer the Account schedule screen
If you want to create the data input from scratch then you can use ODATA web service and can also follow the suggestion of archer.
-Saurabh Shah
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,993 Most Valuable Professional
nmaenpaa 101,156