Thanks for your response. I don't want to show from 2011 January to March 2012, As per your graph If my user selects 2012 March I need to show only from Jan 2012 to Apr 2012 with the running total. And my report is a cross tab. Is this a limitation in Tableau that we cannot able to achieve. Please advice I need to communicate to my client.
Create a date parameter [Select Date]
You can use this formula in cross tab and drag it to filter and select it as true
LOOKUP(attr([DATE (Months)]),0) < [Select Date]
Or use LOOKUP(attr([DATE (Months)]),0) > [Select Date] - to display dates after selected date
Running sum can be calculated for each year, but it gets tricky if we want to display only the selected year data and show running sum of previous years as well.
For scenarios like this LOD can be used but right now Tableau does not support RUNNING SUM in LOD Expressions.
There must be some kind of a hack but not that I'm aware of.