14 Replies Latest reply on Dec 15, 2015 8:29 AM by Simon Runc

    Display - Caption or Tabular Report

    galaxy.tab

      Hi,

       

      I want to build a report out of the attached data. Where 3 lines need to be displayed on my dashboard.

       

      Current Month : 2015-Dec

      YTD : 2015-Jan to 2015-Dec

      QTD : 2015-Oct to 2015-Dec

       

      So to build these I will need to use the columns

      CURRENT YEARCURRENT MONTHCURRENT QUARTER

       

      I want to write a case statement or something on the same lines

       

      Current Month : IF [CURRENT MONTH] = 1 THEN [MONTH] END

      YTD : ?

      QTD : ?

       

      Please help with a sample workbook where we can achieve the same. Can this also be achieved using captions.

       

      Need a good solution that can be expanded through out my development. May also need to format the dates that are displayed.

       

      Thanks.