1 2 Previous Next 20 Replies Latest reply on Feb 16, 2018 2:34 PM by Greg Mooney

    Create a calculated field to determine number of weeks selected in filter?

    Greg Mooney

      I have a data set that let's users selected from any of the 52 weeks of data.


      I want to create a calculated field that will in essence allow me to show in the title of the worksheet that this data is "13 weeks ending xx-xx-xxxx" or whatever number of weeks the user has selected.


      I already have the xx-xx-xxxx part figured out via:


      "13 Weeks Ending " + STR([Max Week Ending])


      But I want to enable the 13 to be variable based on user selection.


      Any ideas?

        1 2 Previous Next