Hi All, Please help me on following
I have a bar chart & two filters. One filter is a date filter & the other one is a field on which the condition depends. The scenario is when I will select the date the chart should display forecasting of future 6 months & past 6 months from that date. Another twist is , if out of past 6 months data are available from 3rd or, 4th or which ever month but not 6th month then the chart should start showing the figures from the month where data are available . Not from the 6th month. Need help to resolve this issue.
