Pivot Chart Filter

[qiyusi]

Hello,

I am not routinely work with pivot table.

Would be appreciate if someone can give me advise about what i am trying to do.

On attached file,

I have a pivot chart with year on year data by monthly, for one product.

what i want, how to set the filter , so the pivot chart will automatically change the product,
current chart is Sum of apple, what i need, when i click sum of apple, i can choose sum of banana or sum of mango, then the chart will change the data.

maybe you can have better understanding if you review the sheet.

Thank you in advance.

[peterrc]

Hi,

I have had to re-arrange your data to get this to work.
On the second Pivot Table there is now a Report Filter to select what you want - see attached.
Will this work for you?

Regards

peterrc

[qiyusi]

Hello Peterrc,

Thank you for your respond, appreciate that.

I checked the alternative table you create, it's a bit unpractical if i have to type the fruit each time i update the data.

Other alternative, I am thinking to create generic chart, then linking the data to pivot table with index formula and dropdown menu to pick the fruit.