Breaking the Trelis Charts

[#1]

I have number of trelis charts and want only to display only the Facilities which have admission figures trending downward ones only.

Appreciate if you could help me.

I have attached the .QVW.  Thanks very much for your help.

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Hi Gysbert

    Thanks for that.

I only want the charts which are trending down, since I can see there the trending up ones.

Thanks

Flavian.

[#4]

Hi Gysbert

Thanks. I have responded to the blog.

Appreciate if you could respond to it.

Thanks

Flavian

[Gysbert_Wassenaar]

My mistake, I misread your requirements. Change the >0 into <0:

only({<Facility={'=LINEST_M(Actuals,Month)<0'}>}Actuals)

[#6]

Hi Gysbert,

Thanks very much. It worked. Also appreciate if you could let me know only to "display the charts of the Actual values which are greater than some value - say 400 for the months selected" so that low valued charts will not be displayed.

Thanks

Flavian