1 2 Previous Next 16 Replies Latest reply on Oct 16, 2013 3:19 AM by John Swimming

    Discrete Date over  "discretized continuous date axis"

    John Swimming

      Hi friends!

       

      Is it possible to figure out this need?

       

      My Date Dimension = Jan-2013, Feb-2013, June-2013

      My Revenue Measure = 3,  5,  7

      My Calc Field = IFNULL([My Measure],0)

       

                                       My Date Dimension

                         Jan-2013  Feb-2013 March-2013 April-2013 May-2013, June-2013*

      My Calc Field          3            5       0         0        0           7

       

      * Note it is a discretized continous date

        1 2 Previous Next