Forum Discussion
Filter
Performance is best if you do this task in the query editor:
Start in your sales table and merge it with the table containing the IDs for EDU and MIL on Offer Id. Expand the result on one field only: Portal.
This will allocate EDU and MIL to the matching items and leave null for all others. Then replace null by the name you want this group to be named.
joschultz - So, is there anything in the "Item Offer ID" that distinguishes an EDU versus a MIL or is it purely based on the Item Offer ID individually? If the latter, then your best bet is to build a table of the "Item Offer ID" and the category like:
Item Offer ID,Category
45322908501,EDU
45188472001,MIL
...
Then you can relate that table to this new table and Bob's your uncle!
What distinguizhers it is the Item Offer Number. I did create a table that has those for MIL and EDU for Ids but there are a bunch of other ones that I dont have that are in sales data I would like to be under the group of General. So that I can slice between the three categories.
IS there a way to create a table with the EDU and Mil offer ids and then have everything else fall under "general"?