Not sure but find my approach based on Union as reference below and stored in attached workbook version 10.5 located in the original thread.
1. Define your UNION
1. D1. Primary/Method:
if [Table Name]='Sheet1' then [Primary]
elseif [Table Name]='Sheet1$' and [Method]='Shooting' then [Method] end
2. Drag the required objects to the indicated locations and set filter for object D1. Primary/Method to exclude NULL
Hope it helps,
Primary_method nalmai v10.5.twbx 49.2 KB
This in fact solved my problem! I did not know you could Union a sheet to itself -- that did the trick!
Perfect!:) Glad is fits you. Thanks for the "Badge". Much appreciated:)
Have a nice one.