I have a pivot table that does not sort from descending order correctly.
For example, i right click in a cell in the totals column of a pivot table and select sort - largest to smallest.
But the total
Is there a way i can arrange the external data calls so my credentials are cached, so i can input my credentials once, and have all other calls to the database use those credentials?
I've tried.