Add Product Name filter that contains the word Avery
Graphical user interface, text, application, email Description automatically generated

Drop the Customer ID to the rows, so these are all customers who have purchased the product contains the word Avery.
Select all these Customers and create a group.
Graphical user interface, text Description automatically generated

Now, right-click on the Customer ID (group) and click on Edit Group
Mark the Include 'Other' Checkbox.
Graphical user interface, text, application Description automatically generated

Now, you have two members in your group. First, one of those who purchased any product contains the word Avery, and the other ones are the rest of the customers.
Remove the Product Name from filters.
Drop the Sales to the Text, and right-click on Sales and Select Quick table calculations -> Percent of total.
Graphical user interface, text, application, chat or text message Description automatically generated
