Pivot chart based on summary column

[MartinDlabac]

Hello,

I have pivot table with several categories (rows) by years (columns). Table looks fine.

I have created the pie chart. It automatically shows only the first year of 2022 (column) of the pivot chart.

Is there a way how can I change this to the total of all years (purple) to be displayed in pie chart, while table displays all the years including the total column at the end?  

Many thanks, Martin

[#2]

@MartinDlabac 

Create a second pivot table based on the same data.

Add the product to the Rows area and the profit to the Values area.

Do not add the year to this pivot table.

Create the pivot chart from the new pivot table.