Conditional show expression

[#1]

Hey guys, have an issue, currently I am showing amount and forecast  and I want to show all months for the chart (currently using show all values in dimension month)   and I want it to show  amount  values up to the month selected  and for the rest I want to show forecast for the months after the max month selected. Thank you in advance

[Frank_Hartmann]

please share a sample qvw.

that would make it much easier to assist!

[#3]

Attached thank you

[Frank_Hartmann]

try that:

Forecast:

Sum(TOTAL Forecast)

hope this helps

[#5]

no thats not working I am trying

Sum({<posting_date={">=$(=min(posting_date))"},fiscal_year={$(=max(fiscal_year))}>}Forecast)

I want months including selected and greater for the selected fiscal year for forecast.   also is there a way to hide the actual from showing if it is showing 0s? as in it is not selected and only show forecast and actual for selected and forecast for every month after selected for the rest of the year.