1 query, 2 sheets with 2 different filters

Hi All,

I was wondering if it is possible for me to have one query in two different sheets with two different filters? For example, in sheet 1, I want the query to give the sales for material A and in sheet 2 the same query results for material B.

I hope I was clear enough. Any ideas on this?

Thanks for your help in advance.