Hello Pppl,
I have a report with a chart( x axis: months with year, Y1 and Y2 with measures) .X axis is expected to display only the last 6 month numbers as default.
The report also required to have prompt which should filter the chart by last 6 to 15 months( 6,7,8,9...15).
so how would i implement this.
How can i initially make the chart to filter to display the last 6 month as default and then filter by prev 15 months which might run into previous years.
Thank you in advance.,
I would break this down into 2 seperate data queries; query 1 to fetch the default 6 months ; query 2 to fetch 6-15 months. Depending on the logic required you can then decide to show/hide the appropriate chart.
Sir thank you for your prompt reply!!!
Since i have been realtively new with cognos. I havent encountered on how to do the show/hide the queries , in a report.
can you help me on how to implement that.
Thanks in advance