1 Reply Latest reply: Mar 4, 2014 12:02 PM by Valerio Fatatis RSS

    Pivot table problem - Time Dimension vs MTD, YTD

    Srikanth P

      Hi Community,

      I am trying to create the below chart and I can't make it happen:

      TimeDim Vs TimeExp.JPG.jpg


       

      I am facing 3 problems:

       

        1.The user needs the Market & its Products in one column like above. the first red circle represents the Market and the second circle represents the Products that Market have. How do I show into Pivot table ?

        2. How do I create the MTD & YTD values for Time dimension value ?

        3. Market growth = CURRENT_MONTH/ LASTYEAR_CURRENT_MONTH. How do I calculate this expression if I have the time dimesion ?

       

      Thanks in Advance....