disconnect field in a table

[#1]

Hello, I tried searching the forum but have not found anything.

Basically I have two tables with some fields in common and some not.
One of these fields is common in the field 'Data'. I would like to filter by selecting the 'Date' only the first table to be filtered, while the second displays all data as if the filter was not applied.

Thanks!

[matt_crowther]

Have a look at 'Set Analysis' in the Help file.

It's a bit complex but if you work through the examples it's easy enough.

Should be something like =sum({1} Value) in the second table to ignore selections in the other.

Hope that helps,

Matt - Viauls Analytics Ltd