Filter Expression For Tablix, Charts and Graphs RRS feed

  • Question

  • Forgive me, I'm very new at this.

    I'm in the process of building a dashboard.  It has multiple datasets with a start date parameter in common.  I have defaulted the parameter to pull in the prior three months worth of data.  How can I filter some of the tablixes, charts and graphs to only look at prior month?  So far I've tried to set the expression as the parameter and this as my value "(DATEADD(mm, - 2 + DATEDIFF(mm, 0, GETDATE()) + 1, 0))."

    Thank you



    Wednesday, August 11, 2010 2:42 PM