Sync Pivot chart/Pivot table Filter
I one of my project I need to show a Pivot table and Pivot chart in a same report.
For now, I have created a PivotTable and PivotChart using this method:
And have successfully added in same report side by side.
But problem is that, If I filter PivotTable, its not updating PivotChart.I want to sync both, so when I update one, it also update other too.
Is it possible in Access or any other idea for achieving same result.