Is Salary or Age field is pre-aggregated fields? If yes then instead of "Include" & "Exclude" use 1 & 0 & make it continuous & then use it as filter. If these fields are not pre-aggregated then problem is something different & for that you have to attach your sample workbook (.twbx) so that we can suggest you according to that.
can you please attach a sample workbook for this case
it will help us to understand this.
I am unable to replicate my case into another workbook since there are quite a few calculated fields. But I will try to describe the situation as much as I can.
Problem Statement : Show rows in a text table that satisfy the logic : ( Age > a ) AND ( ( $VALUE > b ) OR ( CHANGE% > c AND $VALUE > d ) )
The above logic needs three fields from my dataset
Out of these three, CHANGE% is the only pre-aggregated (calculated) field.
Now, here are the methods I tried
- Without the CHANGE% field and without any aggregated functions - true or false : WORKS, but is INCOMPLETE
- Without the CHANGE% field and with ATTR - 1 or 0, and continuous : DOES NOT WORK
- With the CHANGE% field and with aggregated functions - 1 or 0, and continuous : DOES NOT WORK
Can you please help me include the aggregated field and still have the filter work ?