I would like to use customer filter and get the total quantity of the result.
For instance i will select "BW" under "Invoiced By" and select certain product from "Product Name" drop down. Then I need the total quantity as a result. I need to have the option to add multiple filter from multiple column and get the quantity.
Please check the attached file for sample data and then we can discuss more with a chosen candidate.
6 freelancers are bidding on average $24 for this job
Dear client I understand the scope of work. I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy
With the help of slicer u can have the desired output..........................................i added slicer to your data. check whether it is usefull to you..