2 Replies Latest reply on Mar 15, 2018 10:47 AM by Greg Mooney

    Create Custom Time Frames in Text Tables

    Greg Mooney

      I have a workbook with weekly data in it.

       

      I would like to create 5 times from that data; Latest 4, 13,26,52 and YTD

       

      I have already created these time frames with the Group Members function.

       

      Now I need to be able to have these 5 time frames as rows in a text box and 2 measures in columns like the table below.

       

                          Sales          Units

      Latest 4

      Latest 13

      Latest 26

      Latest 52

      YTD

       

      Any help?