I currently have a visual displaying % of sales of items by item category. i.e. how much does each item category contribute to the total number of sales.
However, when I filter for a particular category to see it in more detail (since there are so many), the visual displays a percentage of 100% because this is technically correct since the grand total of the current selection only includes that one category.
How can I get the visual to display the % of total sales, regardless of any filters applied?