Nested Sorting in SAP ANALYTICS CLOUD Table

[former_member258682]

Hello Experts,

I have a requirement of doing nested sorting in SAC Table widget.

In below example I want to sort Rank column based on both Parent & then Child.

Is it possible in SAC Tables? According to my testing we can sort only based on 1 column at a time.

Thanks,

Sarthak Srivastava

[Jay_Gandhi]

Hi there,

Martin is correct. However, to be clear you cannot dually sort one dimension and I only bring this up because I see you're using the term parent and child which usually denotes one dimension and a hierarchical relationship.

If that's not the case then as Martin described, you're able.

Jay

[mfoeken]

Hi Sarthak,

If you select the dimension header you can apply sorting. In the screenshot below I applied sorting on both columns.

Is this what you mean?

Kind regards,

Martijn van Foeken | Interdobs