1 2 3 Previous Next 37 Replies Latest reply on Dec 24, 2013 9:28 AM by Jonathan Drummey

    How do I take the last value for each month (data collected weekly) and use that value for monthly trend?

    Eric Munisteri

      I do not want the monthly values to SUM, I simply need to use the last value provided for the last week of each month and use that value to create a monthly trend line.  A calculated field is preferred as this report will be automated and I can't make date selections from the filtered dimension.  Any help would be truly appreciated.

        1 2 3 Previous Next