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 kimView original