I have a solution - it's not perfect, depending on your exact requirements.
See attached workbook. First, I have created a field "Concat" which concatenates all part attachment excluded values for a serial number (note: this is hardcoded to the possible values you listed in your example - so it has limitations if there are e.g. hundreds of these and/or they grow over time this probably isn't a good option)
Then I have created a parameter based on the part attachment excluded and then a calculated field to test whether the parameter selection is contained in the concatenated list. We add this to the filters shelf to exclude anything that is contained in the concatenation field.
Exclude Filters.twbx 34.2 KB
Hi Paul Field
Thanks for your reply.
I also created based on my requirement and it seems of kinda working but request you to check it as i have done by creating custom SQL and parameters.
But the problem with it is that i am not able to show all data when i don't want to include and exclude.
NOTE : Workbook Attached
include_exclude.twbx 13.8 KB
If you update your custom SQL to handle the "All" for the include filter, I think it should give you what you're after:
select * from [sheet1$] A
where ( A.[part_attachment included] = <Parameters.Include> or <Parameters.Include> = "All")
and configuration_id not in (
(select distinct configuration_id from [sheet1$] where configuration_id in
( select distinct configuration_id from
[sheet1$] where [part_attachment included] = <Parameters.Include> or <Parameters.Include> = "All")
and [part_attachment included] = <Parameters.Exclude>))