Forum Discussion
Filter on table and column
Hello, i have two tables, one that has the stock of each product and the second has a cloumn that has the names of the products purchased. each row of this column contain one product purchased, so if...
Hi V-Piga-msft
Yes correct, the filter will be Book, Pen, Pencil and Toy.
as for the results i want to know how much Books left in stock after all the purchases and stock top up, so if i select Book for example, it will tell me you have so and so left in your stock for books...
Omega
Impactful Individual
Impactful IndividualIf that's the case, then you need to apply a countrows for the first sheet where you will be counting the purchases. Then, take the difference of the sum of stocks from the second sheet.