Measure Range Calculation

[kavirao]

Hi 

I do have use case where I need to generate a report based on 2 custom variable selection.

I am calculating the sum of sales based on 2 selections which are variable input not a dimentions

1) Sales Type - options are (Direct , Indirect , Others) based on selection it will calculate sum

sum(if($(vsaletype)  =1  , Direct , if($(vsaletype) = 2, indirect , others)))

2)Sales Range - Options are ( < 100000 , > 100000 , 100000 - 1000000, 1000000 -2000000,2000000-3000000)

I need to include this range into after calculate sum of sales using salestype. 

Let me know any solutions on this

Thank you

Kavitha