Showing results for 
Search instead for 
Did you mean: 

1 query, 2 sheets with 2 different filters

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

You can try creating the workbook with the same query in both the sheet. Then goto the change mode of the local view (not the global view) and restrict the values with Material A and B respectively.