How do I filter measures in Sap Analytics Cloud table?

[Former Member]

Hi

I am using a story which requires me to show sales opportunities which have 0(zero) value against them.

I want the table in my story to be filtered, so that it only shows opportunities that have zero value.

Can you please advise how this is achieved, as currently i can only see option to filter by dimensions.

Thanks you for your help.

[former_member1186610]

Hi Alim , you got any resolution for you issue please share with us in is very helpful

[JohnL · Accepted solution]

Hi Uzair,

You'll need to create a measure based dimension. My example I had two members in the measure based dim called OnlyZero and MoreThanZero.

Make sure Opportunity is in the dimension context when you set that up.

See https://www.youtube.com/watch?v=yARQ6zOA1hQ

[Former Member]

Thanks Tammy,

What you are applying is a story level filter, whereas I only want to apply filter to a particular table, "without" affecting any other data on my Story page.

For example, I want to show all opportunity id's for sales people who have a opportunity value as 'zero', then how do I filter the table?

Attaching screen shot for your reference.

Appreciate your help on this.

[TammyPowlas]

Hi - I am able to do this using the Filter icon:

If you still have issues, could you please share a screen shot?