Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Try If you allow Macro
Any other approches ?
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