Forum Discussion
Pivot chart based on summary column
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...
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.