Post reply

Matrix data hidden based on first month of another dataset

  • February 10, 2015 at 10:32 am

    #398004

    Hey there,

    This is my first post to the forum. Thanks much in advance.

    I have 2 tablix on on report with different datasets. The first is agent level by month. The second is the agent's supervisor metric by month where the dataset is pulling in year to date. More specifically, Jan 2014 to current month. My issue is that if a agent starts in Apr 2014 i want to restrict the Agent Supervisor metics data to only show Apr 2014 to current month.

    My attempt was to set the Visiblity on the group properties to the following:

    =iif(Fields!Month.Value<First(Fields!Month.Value, "InboundMetricsYeartoDate"),false,true)

    but the results only hide the line for Apr 2014 rather than all less than Apr 2014.

    Any ideas? Thanks

  • February 10, 2015 at 11:48 am

    #1776722

    so after altering my expression to the following:

    =iif(Month(Fields!Month.Value)<First(Month(Fields!Month.Value), "InboundMetricsYeartoDate"),true,false)

    i'm getting closer. the results show data for the months >= to Apr 2014 but are not showing the 2015 months. NOTE: both dataset contain a year column so is my "Month" expression limiting my visibilty to only the months in 2014. The format for the Month field is "January 2014","February 2014" etc.

    with that said would you suggest a nested iif statement or possibly an "OR" to add multiple criteria to the visibility group properties.

    here is my attempt of the "OR" but still gettign and error:

    =iif(Month(Fields!Month.Value)<First(Month(Fields!Month.Value), "InboundMetricsYeartoDate") OR (Year(Fields!Year.Value)<First(Year(Fields!Year.Value)), "InboundMetricsYeartoDate"),true,false)

    thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply