Skip to Content
0

How to apply filter on measures

Sep 07, 2017 at 09:30 AM

8

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers