1 Reply Latest reply on Aug 31, 2018 2:31 PM by Patrick A Van Der Hyde

    Dynamic month filter against another month filter.

    sanjog ram

      Hi, i have a cross tab showing data for a particular month.  find the attached file for reference.

      i have a filter of month to show the data of particular month.

      now i want another  filter of month to change the dynamic field.

       

      let the login and sanction coming from last month leads so the dynamic field show the data of login and sanction coming from previous months leads.

       

       

      challenges:

      1) if i select august from month filter so the data will show overall sanction and login data.

      2)but if i select the month July from dynamic filter so the data should reflect  login or sanction values coming from July months leads

       

      leads= unique id

      the cross-tab have relationship  of month and unique lead id.

      i am unable to make a calculated field to make dynamic filter