Sorting by date in SAP Analytics Cloud

[former_member1324619]

I am struggling with a feature that should be simple and self-explanatory. Sorting - especially sorting by date.

I have a linked widget that shows cost details per posting date for a given WBS or Supplier. The details are correct, but I cannot sort the postings by date - they just appear randomly, which is not accepted by the user base - and there is no real explanation why such a basic thing is not working. Posting date is part of an hierarchy, but in flat representation,

Nothing happens when I sort the Posting Date field Highest to Lowest (or the other way around). All other columns have the default sort order.

I have seen it working at first - but then I needed to add a further column to the table and now the sort is gone. 😞

Does anybody have an explanation here?

Thank you,

Susanne

[JBARLOW]

If you set the date dimension in the table to display both ID & Description
Is the sort being applied to the ID?

[Katryn_Cheng]

Hi Maria,

How is it "linked"? Is it linked analysis or does the table have a blended model?

Is the Posting Date a Date dimension?

It would be helpful if we could see a screenshot of the behavior (with sensitive data blurred out of course). I am trying to get enough details to test it out on my end.

[former_member837941]

Hi Maria,

Could you check this below link.

Changing Member Order | SAP Help Portal

Thanks,

Saurabh