Skip to Content
avatar image
Former Member

How to apply filter on measures

Hi ,

I have a scenario where I have to filter out my data based on the sales amount range. Such as between 0 to 500 data in on table , 500 to 1000 in another and so on. I created a webi query on the same but sales amount between 0 and 500 condition actually retrieves data where sales amount is more than 500, So the filter applied at where clause is not working.at the query level in webi

Say Dimension : Country , vendors, Product, Model

filter all those in ranges 0 to 500, 500 to 1000 sales amount .

please help with the solution.

Thanks,

Charu Thareja

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers