0 Replies Latest reply: Nov 4, 2016 7:26 AM by jeevayswaran a RSS

    how one expression will work based on one dimension and another expression work based on both of two dimension

    jeevayswaran a

      Hi all,

      I have t data like this,

       

      NameDatePNL
      A1-Sep-1610
      A2-Sep-165
      A3-Sep-162
      A4-Sep-163
      B1-Sep-1620
      B2-Sep-165
      B3-Sep-163
      B4-Sep-162
      C1-Sep-1610
      C2-Sep-1610
      C3-Sep-162
      C4-Sep-165
      D1-Sep-1610
      D2-Sep-165
      D3-Sep-165
      D4-Sep-1610

       

      from above data i need the result like below. in YTD field sum of PNL from year start to month end (i.e4-Sep-16). here month is September. and month end is 4-Sep-16. if i select a date, the result will come in MTD as well as YTD, and the dates (i.e 1-Sep-16 to 30-Sep-16) will come month start to month end of selected date.

       

      Result:

       

      NameMTDYTD1-Sep-162-Sep-163-Sep-164-Sep-16
      A2010010523
      B3020020532
      C27300101025
      D30250105510

       

      I have Name and Date as dimension. i need Name wise MTD and YTD and date wise. but date is presented in like column name as above.