PastData:
MonthYear TopClients
03/2010 .68
06/2010 .68
09/2010 .62
12/2010 .65
03/2011 .64
06/2011 .65
09/2011 .67
12/2011 .65
I create a Line Chart and use Count() function to calculate vlaues over time form another QVD file that contains data from Jan 2012 onwards.
I need to append above static data to the begining of the line chart (as it is) and show calculated values from 01/2012 onwards.