2 simple questions about SAC table

[Jason233]

Hi,

Here are two simple questions we want to figure out:

1. Is it possible to sort by 2 measures on a single table?

2. How to filter the rows where the corresponding measure value > 25%?

Thanks for your help.

Regards,

Jason

[gregoire_byrka · Accepted solution]

Hi Jason,

It is not possible to sort on 2 measures in a table, sorting depends on 1 aggregation only. I am not sure what is your use case, but let's say you have revenue & margin as measures and customer as dimension, the sort cannot be on both revenue & margin.

However, we are working on providing sort on multiple measure/dimension aggregations, e.g. sort on revenue by country, and then by customer. You can vote on this idea if this corresponds to your use case https://influence.sap.com/sap/ino/#/idea/262839 It should be available with QRC3 release.

Regarding the filter on measure, it is not available for all models. If it is, select the table, scroll down in the builder panel to the filter section, select the measure and in the dialog, then chose the dimension aggregation and the operand. Again, we are working on delivering more capabilities on this for QRC3 release.

Thank you for your patience

Greg

[Jason233 · Accepted solution]

Hi Greg, thanks a lot. It's really helpful.