3 Replies Latest reply: Apr 19, 2014 2:38 PM by Rachael Chan RSS

    Calculated dimension for max date of each month

      dates.png

      I'm trying to get a calculated dimension so that only one date for each month is shown in the dimension, how do I do this?

       

      Based on the example above, I want my dimension values to be:

      1/04/2014

      12/31/2013

      11/11/2013

      9/30/2013

       

      Any help would be greatly appreciated!