Question one: cell F$2-$ Use a formula referring to other amounts in the road to calculate total units

Your next questions are in relation to a pivot table, please tell me how to filter the pivot table to get the right answers. I also do not know how to some filters on Mac so please help me with that too. The filters are months, Donatello model, Leonardo model, Michelangelo model, Raphael model, total units, sales amount, customer, region, sales person

Question one: listed by salesperson, what is the lowest amount of total sales in june and july for kirby co$.?$

Question two: listed by region, what is the fewest number of sales invoices in june?

Question three: listed by customer in the north and south regions, what is the second lowest average sales amount?

Question four: what percentage of those units were the raphael model?