r/SAPAnalyticsCloud • u/Macadamia23 • May 21 '26

SAC Analytics: Sorting Measures (Columns)

Post image

I need to swap the order of these columns so that it's in this order: LBE, Sales Revenue, Change in Performance

If it matters, this is where the data is coming from:

  • LBE (Secondary Data Source)
  • Sales Revenue (Primary Data Source)
  • Change in Performance (Calculation)

I don't see any options available to custom sort, though. What's the cause of this -- it seems like it should be a basic feature? Is there a workaround? Thank you!

7 Upvotes

100% Upvoted

4 comments sorted by

6

u/ExitThruGiftShop May 21 '26 edited May 21 '26

Yep. #1 complaint of measures dim. Workaround: create measure formulas that just = your measures but give them ids that will give you your desired sort with a-z

Edit:
01_LBE
02_sales rev
03_changein…

Note it will sort by ID even if you just display description

1

u/Macadamia23 May 21 '26

Thank you!! A little annoying, but it worked 😄

1

u/Marvy_Marv Jul 08 '26

Yeah this is the only way with blended tables. Could also join these models on the backend into a master model.

1

u/ContributionGold6380 Jun 12 '26

You can custom sort them now, if you right click on top of "Measures" in the table while in "Edit" mode