Hi all,
I got an Excel sheet for an inventory system.
An item can be at multiple warehouses and in multiple conditions (in the same warehouse).
I would like to make a slice for all the items that are in warehouse A but don't exist in any of the other warehouses.
I hope someone could help me.
Thanks in advance!
Jelmer
Solved! Go to Solution.
@jelmer130 wrote:I would like to make a slice for all the items that are in warehouse A but don't exist in any of the other warehouses
AND(
[Warehouse]="A",
NOT(
IN(,
[ItemColumn],
SELECT(
Table[ItemColumn],
[Warehouse]<>"A"
)
)
)
)
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |