Hi,
I have an inventory app. For adding a new item form:
ID[uniek]{text type} item name{text type} category{EnumList}
for example: ID- “XTY4421” Item name - “banana” Category - “fruits, yellow, happy” (I choose 3 categories)(3 values in one cell)
is it possible to use the Select function if only one of the categories is equals? In order to open a list that related to a category.
for example: I pick “yellow”, and the item list will “banana”. or if I pick “fruits” ill get “banana” also.
thanks in advance.
You can use syntax as… SELECT(TableName[Item Name],IN([Category],[_THISROW].[Category]))
Thanks, but still not working. I don’t see the items that have several categories. only the item that has one category
#ERROR!
Let me test this…
OK now I manage to succeed!
=SELECT(Stock[items],and(in([_THISROW].[catgory],[category]),[in stock]=Y))
Okay good. I probably misunderstood you column structure slightly.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |