This works only when I have not selected any date related filters in my report. If I select a date related filter (say 2009), only the first one works and second one doesn't refresh data. It always gives the [sales] column value.
Is there anything that I am missing in my expressions?
The issue comes when you select a particular year and then change the 'Report On'.
For example, if you select year '2008' in the year list, the graph will show 2008 and 2007 data(two bars). After this if you change 'Report On' value, the graph data refreshes only for 2008 (bar in the graph) but not 2007 (bar in the graph).
The problem still exists. Please check my example below.
The data is
Year - Sales - Ledger Sales
When you select year '2008' in the list box and change report on to 'Ledger', the graph shows 2007 (1800) and 2008(2100). Here is the problem as 2007 is showing sales instead it should refresh to ledger sales.