Solved: Percent of Total Ignoring Filters - Page 2

kim2 · 06-29-2021 02:03 PM

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.

kim2

Thank you very much for the detailed response. That was a huge amount of effort and I appreciate it.

However, I found that it is easier and far better for database performance to (1) add a bit flag in the dimension table coupled with a (2) yesno measure to the LookML view and (3) create a table calculation that “Hides ‘No’s’ from Visualization”.

The table calculation is

${shareofsales.total_sales}/sum(${shareofsales.total_sales})

View solution in original post