5 Replies Latest reply: Feb 28, 2018 4:06 AM by Pablo Labbe RSS

    Need to show result in latest month in pivot table

    Himadri Laha

      Hi,

      We have the following requirement:

       


      ID

      OutcomeDate
      1234abcd20th Oct 2017   
      1234bcde20th Sep 2017

       

      We need to show the days difference between two Outcomes,when the ID is same.

      and will be showing in a pivot table,which shows the month wise values.

       

      In pivot table we need to show in Oct 2017 , and the result will be 30 for this above example, how we can achieve this scenario ?

       

      Thanks in Advance...