We have a Pivot where the columns have to be in specific order - not alphabetical. For example, we have facility levels named - CPA, PPA & FOSA, they come alphabetically like - CPA, FOSA, PPA, but we want the exact sequence - CPA, PPA, FOSA, then NATIONAL then SHIPMENT.
Any way to mention sort order different than alphabetical? Excel and Microsoft BI has the feature. See the screenshot.