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