I want to filter based on:
Revenue < 100
How can I do this?
Filter in during the load?
May be this after your load statement
Where Revenue < 100;
If Revenue is a dimension, you can do numeric search. If it's a measure, you can do expression search.
Would I have to select each value 1 by 1? When I click "Select Possible," all values are are selected. Even the values greater than 100.
After you've typed your condition, just hit enter - it should select relevant values.
Retrieving data ...