Pivot Chart Slicer show total when all options are selected

Hi,

I have a Pivot Table and Pivot Chart that shows the quantity sold of a product, with the option to be filtered by year sold, state sold, and product sold. I currently have the data displayed in a column chart, but it looks a bit cluttered since it produces a column for each product and each state. I have slicers for the year, product and state so that I can filter down to see a specific state and/or product over time, but when I have multiple states/products selected I have the cluttered column problem.

Is there a way to set up the chart so that when I have multiple products and/or states selected at the same time the chart will sum up and display the aggregate totals in a single column per year instead of a single column for each product and each state in each year?

For example, if I have all states and products selected by the slicers, I want to make it display the total sales for each year. If I have one state and all products selected, I would like it to display the total sales (all products included) for each state over time with one column per state. If I have one product with all states selected, I would like it to show me total sales for that product in each year that is in the filter.

Here is some sample data with a sample chart and slicers already created up to the point that I just described. Thank you for your help!

Hello,
To do this you need to combine the sales tables into one (the more it is easy because they have the same data layout).
Only on the combined table, create a data model. Combine tables with Power Query and add to the data model.
Regards

That makes sense, thank you!

I didn't realize that I could remove a field from the pivot table field list and still use it as a slicer. Thanks for the help!