Change data sorting while exporting to excel

v_jaideep · ‎2020-04-01

Hello,

I have a pivot table where data is show from Jan’19 to Dec’19 but when I export to excel I need data to be exported in reverse order that is Dec’19 to Jan’19, Dec’19 to be top on the excel. Is there any feasibility to implement in QV ?

Anil_Babu_Samineni · ‎2020-04-01

Try If you allow Macro

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

v_jaideep · ‎2020-04-02

Any other approches ?

Brett_Bleess · ‎2020-04-22

To Anil's point, the only way I see to do this is via a macro using our APIs to change the sorting of the pivot table prior to doing the export via a button object. The only other way would likely be a macro in Excel to do it there...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Excel Exports