Forum Discussion

shady_hamilton's avatar
shady_hamilton
Regular Visitor
7 years ago

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...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi shady_hamilton,

 

Do you want to create a dropdown list with values of Toy, pencil, book and pen?

 

 

If it is convenient, please share your desired output so that we could help further on it.

 

Best  Regards,

Cherry

shady_hamilton's avatar
shady_hamilton
Regular Visitor
7 years ago

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's avatar
    Omega
    Impactful Individual
    7 years ago

    If 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. 

  • shady_hamilton's avatar
    shady_hamilton
    Regular Visitor
    7 years ago

    countrows is fine, I did that, my problem is the formula where you change that every time you change the filter, so when i select books in the filter the box showing the available stock should show me the books stock, if i select pens then the box should show me the Pens stock and so on...