Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to display a table with information, but I want to exclude all information where field1 <> 0 and in field2 does not have a value of say 'A'. Best would be set analysis but i want the values to change as other selections are done, those two fields though have to be constant and not include any other rows of data
The initial table already needs to only reflect data where field1 = 0 and field2 = 'A', even without selections being made
Any help would be greatly appreciated
Andre
Attached is some sample data
Maybe the way forward is to flag the fields in the original import