I need to implement a numeric filter (REVENUE) which should pull the corresponding values from a dimension column (Order Number , which is not unique) and then entire dashboard should filter data corresponding to the order number which fall in the range of revenue.
Revenue check box filter should have following values:
Now when user selects 0-50K range then all the sales order number corresponding to the revenue range of 0-50K should be selected and the entire dashboard should show revenue only for the order numbers corresponding to selected range.
Note : There can be multiple transactions with revenue less than 50K but when it is summarized at the dashboard at a particular level (e.g. country or region) then summarized (overall) revenue can go well beyond 50K to millions. depending on number of transactions
so basically 2 things are required.
Creating the numeric filter which is range bound as shown above with check boxes.
and second i need to make sure order number is considered only for the selected range and entire dashboard should be filtered and show data/revenue only for the order number belonging to the selected revenue range.