What is the best method to find the percent of total sales while ignoring all filters except one (the date)?

For example: We sell 100 products. I want to plot only 5 products on a line chart by month vs percent of total sales (the total of all 100 products).

Also, we need to plot a selection of product category percent of total sales while only showing one or two category names.

The formulas in this documentation do not address that.

**Best answer by kim**