I have Brand,item,region and revenue in columns a,b,c and d respectively
each brand has multiple items and each item sells in multiple regions
My objective here is to Filter for a brand-item combination and calculate the sum of the revenue at all regions
take the range as a1000,b1000,c1000,d1000
the output should be displayed in the next workbook as

Brand Item 200000
Pepe jeans 500000

i.e brand item duplicates need to be removed and sum to be displayed alongside


Thanks in advance