My goal is to almost build a master dimension list. The data I get does not have a category column so I have to find a way to create a dimension: (I would have t set of four or more master dimensions)
IF FruitTable1 = 'tomato' or 'artichoke'
IF FruitTable1 = 'watermelon' or 'cantaloupe'
But that formula is not a way to create a dimension and invalid as it lacks a "then" . I want to write a formula that creates a master dimension based on a list.
I tried to create the second spreadsheet as 'master table' as I could teach sales to easily build and save by tab 'categories' they want to group but like you said... how this then can be set as a dimension value when searching the main database is what I don't know how to do.
Most categories they will want to group are four of five parts.. others are hundred....hence the list vs VERY long string of 'or...'