I believe your concern is about sorting columns order by some default range.
While it is not doable to manuallyy select an order of columns you can play withh CASE formula renaming them innto a certain order for example adding a number or a letter before theh name.
Something like
Case
when "field" = Z then 1. Z
when "field" = A then 2. A
end
This way whehn you sort your pivot table column by dimension ascending you shhould acchhieve thhe desired goal.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |