SAP Analytics Cloud: Conditional Format as a Filter

[djk13]

Hello Experts,

My question is, does filtering via conditional formatting exist in SAC?

I have a set of values for which I am trying to calculate the standard deviation. The only issue is the data set has some exclusions that must occur for the Std. Dev. to be correct. I have identified the criteria for the exclusions and have set them to display via conditional formatting.

When I set up my visual, I would like to exclude these data points. Can I simply filter by or the equivalent thresholds. If so, how? I have been unsuccessful so far.

Thanks!

[former_member838037 · Accepted solution]

After creating the Threshold, you need to create a Measure Based Dimension, based on the same measure and dimension.

And after that, you can just use the Measure Based Dimension as a filter for your table, which will do the work.

This is the unfiltered table and the threshold settings.

After that, this is the MBD that I have created which has the same setting as the threshold.

Then I used the MBD as a filter for the Table, which gives the following result, consisting of only the High Threshold values.

Thanks, hope this helps you.

[djk13 · Accepted solution]

Thank you so much argha2000! I appreciate it. That is working for me so far 🙂

The application of 'REO GOOD' as a filter in the corresponding charts within my story also works.

Perfect explanation, upvoted and accepted!

[former_member838037]

Glad it helped you djkoenig .