two field contains sales ids (say A and B). create field that give IDs that are in A but not in B and other field give IDs that are in B but not in A

Hi @Diksha Joshi​ 

I've got a sense that a UNION and then SETS would help you here.

The UNION to create the combined list of IDs.

And the SETS to look for the cases that don't intersect.

https://help.tableau.com/current/pro/desktop/en-us/union.htm

https://help.tableau.com/current/pro/desktop/en-us/sortgroup_sets_create.htm

Let me know if that helps, and please do feel free to post back with a packaged workbook (TWBX) attached where some representative sample data is included + extracted first.

Ta, Steve