Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table with a dropdown selector for year and quarter. Is there any way to change the sort to be descending by year and quarter?
It's based on a drilldown dimension:
Hi, Scoot Green.
The fields year and quarter are as dimension in pivot table?
Regards,
Jonas Melo.
Hi Jonas, sorry I didn't get back to you right away; but I was on vacation.
Yes the Year and Quarter are dimensions in the pivot table.
Hi, Scott Green.
In Desktop version, follow the steps below:
Hope this helps!
Hi Jonas,
Thanks for the input; but I'm running the Enterprise Server version.
No problem. Make the change in the file .qvw, then deploy it on the server.