[WORKSPACE] Sorting by dimensions | Community
Skip to main content
Level 4
Nov 16, 2017 6:12 PM UTC
Delivered

[WORKSPACE] Sorting by dimensions

Since the prehistory... In Adobe Analytics the possibility of sorting by dimension is something impossible.

Now we have workspace and I really dream to have it.

In freeform table we can sort by value we have in columns but not by value we have in rows. Please let's make it !! There are tons of reason why we need it. Try to think about a report where I'd like to have data sorted by Category of products, Zip codes, Order Id, Attributes of product...

19 replies

JayGr
Level 3
Oct 10, 2025 6:45 PM UTC

@fwachsmuth this is a great workaround for dimensions which don't expect new values. Thanks for the tip.

Translate
acookie4rachel
Level 2
Aug 26, 2021 6:40 AM UTC

@fwachsmuth  Thanks for the workaround! It's odd that we can only sort the selected dimension items.. this workaround is good for now for reporting purpose. 

Translate
Level 2
Aug 26, 2021 5:37 AM UTC

It's doable if you have less than 400 values in the dimension. The trick is to mark them all, right click and chose "show only selected rows". Once done, they are sortable. 

Caveat: new values won't appear in such a table until you change the selection. 

Translate
acookie4rachel
Level 2
Aug 25, 2021 7:12 AM UTC

Any good news on this? I need to sort 'Industries' dimension alphabetically because client is used to viewing Industries by alphabetical order. The client finds it messy and hard to visualise when the industries are sorted by a corresponding metric.

Translate
New Participant
Feb 24, 2021 7:06 PM UTC

Yes please add! Thank you

Translate
trevor-paulsen
Employee
Jan 26, 2021 11:03 PM UTC

The good news is that we actually now support this in Customer Journey Analytics for all dimensions. The bad news is that for technical reasons this isn't possible in traditional Analytics. For more information on CJA you can check out:  CJA Spark Page

Translate
Level 2
Jul 27, 2020 2:40 PM UTC

I found a workaround for this which works well if the permuttaion count of your dimension is <= 400:
- Show all dimension values in a freeform table
- Select all of them
- Right-click and "show only selected columns"

 

-> Voilà, you can now sort by them. 

 

Dangerous though if new metrics would come in, since they wouldn't be shown. 

Translate
Level 2
Oct 18, 2019 2:02 PM UTC

This. So much. When can we haz it?

Translate
Balaji_V
Level 4
Aug 6, 2019 8:44 AM UTC

Sorting by alphabetic order at easy

Translate
kumararajak
Level 5
Aug 1, 2019 11:46 AM UTC

Requied one

Translate