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