I have a column that I need to group by an ID number. I have a list of 25 IDs that I need to split into two groups but then would like the rest put into a third group so that I can slice on these. What is the best way to go about this?
@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
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"?