5 Replies Latest reply on Aug 9, 2016 1:58 AM by Maheshh C K

    How to incorporate a calculated field for same measure when displayed across quarter of date dimension.

    Maheshh C K

      Dear All,

      My requirement is to incorporate symbols to mark trends in a
      list report. The measure value is shown across date for different Attribute. My
      requirement is to mark the following in a separate column.

      1. ↑           -
        The value of the latest quarter > The value of the first quarter (whereas
        the quarter is                         parameterized
        by the user)
      2. ←→       - The
        value of the latest quarter = The value of the first quarter (whereas the
        quarter is                         parameterized
        by the user)
      3. ↓           -
        The value of the latest quarter < The value of the first quarter (whereas
        the quarter is                         parameterized
        by the user)

      In the attached .twbx I have brought the measures across the
      quarter & made a filter on the date. However kindly help me in parameterizing
      the filter & mark the symbols.

      Input:

      Row#

      Attribute

      Date

      Value

      1

      A

      1-Apr-15

      10

      2

      A

      1-Jul-15

      15

      3

      A

      1-Oct-15

      20

      4

      A

      1-Jan-16

      25

      5

      B

      1-Jul-15

      30

      6

      B

      1-Oct-15

      35

      7

      B

      1-Jan-16

      40

      8

      B

      1-Apr-16

      45

      9

      C

      1-Jul-15

      50

      10

      C

      1-Oct-15

      55

      11

      C

      1-Jan-16

      60

       

      Expected Outcome:

      Assuming the filter is made from 2015 Q3 to 2016 Q4 in the
      date filter the trend is automatically calculated for A attribute from Value of
      2016Q1 > 2015Q3 & hence the upward trend. On similar lines for the
      Attributes B & C as well.

       

      2015

      2016

      Trend

      Attribute

      Q2

      Q3

      Q4

      Q1

      Q2

       

      A

      10

      15

      20

      25

       

      B

       

      30

      35

      40

      45

      C

       

      50

      55

      60

       

       

      Attaching the .twbx for the same.

      Thanks

      Maheshh