Thinking how to accomplish filtering on field that is not displayed and ran into a few roadblocks. E.G. -
1. If I put the desired field in the "FILTERS" section, I can't filter on value (i.e. - want to keep all observations greater than 1,000,000
2. The desired field to filter on is not in the values section, thus can't use it as a filter.
3. Tried to add a calculated field, but not sure of the syntax. Should be something like "=if(CurrentFace >= 1000000 then 0 CPYSpread else 0).
Thoughts??
1. If I put the desired field in the "FILTERS" section, I can't filter on value (i.e. - want to keep all observations greater than 1,000,000
2. The desired field to filter on is not in the values section, thus can't use it as a filter.
3. Tried to add a calculated field, but not sure of the syntax. Should be something like "=if(CurrentFace >= 1000000 then 0 CPYSpread else 0).
Thoughts??
