I am attempting to replicate the Sales Dashboard demo report in that you have a line chart within the pivot table.
I have a simple dataset that has my categories of items as row data and the months as columns. The pivot table is reporting all data properly.
I create a line chart outside of the pivot table and it displays correctly in that all categories are plotted on the chart. I then move that chart into cell within the pivot table.
Upon preview, for each row, the chart is displayed but shows all categories rather then the data for the category row.
It appears that there is no "filter" being passed into my chart. I have attempted to review how you did this in your example but can't seem to figure it out.
Would it be possible to get some screen shots showing what needs to be done to pass the current rows "ID" into my chart to filter it?
Note that going back and forth between my report and your sample causes the properties windows to collapse so it is easy to loose where you are looking in the properties section.
Any help would be really appreciated. Thanks.