I have a requirement to display the chart based on the current year.
Ex: Assume i executed the document on March 2013, Line chart with X axis as Cyclic Group: Year>Month>Week. When i open the document i need to display the line chart based on the current year (2013) and further if i drill through to Month then the chart should display Jan, Feb, Mar data and if i further drill thru the week then it should display the week numbers based on the particular month.
Please let me know the solution. Thanks in Advance!!!
When you open a document you can use triggers (you find them in document properties -> triggers) then set the field (or variable) value to the current year value ....
In triggers i have set the field value to the current year, if i open the document the current year will display initially but in chart if i further drill down on month its showing previous year months data also but i need only the current year months data should display in chart.
