Create a filter pane based on ranges of measure values

[Jorich919]

I have a pivot table with dimensions of Company, Date, ProductID and a measure column of Revenue.
How can I create a filter pane that lets the user filter my table based on the values in the Revenue field?

There are some Revenue values that are $0, so I would like the user to be able to click the filter pane to end up with only the Company, Date, ProductID where the Revenue is $0.  By default the table will be full of all values, but user to be able to click for just the $0 ones. 

Thanks!!

[StarinieriG · Accepted solution]

Hi,

you could create a new field inside script using if.

If(Revenue = 0, 0, If(Revenue <1, '0-1', ......)) as Filter

[Jorich919]

Ah ha!! That works perfect.

Thank you StarinieriG !!