7 Replies Latest reply on Feb 5, 2018 4:36 AM by Matthias Giger

    Select two date dimensions in a calculated field

    Matthias Giger

      Hi, I'd like to build a View where you can select the desired measure.

       

      I don't have problems selecting the groups.

       

      CASE [Selection]

      WHEN 'SelectedValue1' THEN [Dimension1 (Group)]

      WHEN 'SelectedValue2' THEN [Dimension2 (Group)]

      WHEN 'Date' THEN Year([Date]) ?+++? Month([Date])

       

      However for 'Year' I'd like to select the year and the month of the discrete date dimension, so the view acts as if they were both on colums: Year(Date) Month(Date).

       

      It is well possible that the solution is basic. Sorry if that is the case.