topic Re: Filtering data based on measures in App Development

Filtering data based on measures

sujeet_shirude — Mon, 20 Dec 2021 21:08:46 GMT

Hi everyone,

I have a data set similar to attached. I have created a master measure for sum(Sales Amount). In a table, I want to be able to enter greater than, less than or equal to value in the sum(Sales Amount) and filter the data.

What will be the best way to do this?

Any insights on this would be appreciated. Thank you!

Regards,

Sujeet Shirude

Re: Filtering data based on measures

SerhanKaraer — Fri, 05 Jun 2020 13:10:49 GMT

Hi Sujeet,

You can convert an expression into a dimension with the help of Aggr() function.

Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)

By this way you can provide filtering option for users.

Re: Filtering data based on measures

sujeet_shirude — Fri, 05 Jun 2020 13:33:41 GMT

Thanks a lot, Serhan!

It worked.