4 Replies Latest reply: Oct 18, 2018 9:16 AM by Satya Ppaleti RSS

    How to Add YTD including with total in Pivot Table

    Satya Ppaleti

      Hi Folks,

       

      Could some one please help me on this requirement

       

      I am creating a pivot table and I have Fields Date, Month, Categories and Sales. I am creating two reports

       

      in Report 1 Dimensions are Month and Categories and Expression is Sales

       

      mnth.JPG

      In this I need to show only previous months data and Max Date's month should be skip and This is working fine

      Max Month report should show in dates like below report

       

      mnth.JPG

       

      But here at the bottom we are providing some of the sales for september month but I need YTD also along with this september sales. Could some one can please help me on this. It will be very appreciatable

      Please find attached documents for sample qvw & sample data

       

      Thanks and Regards,

      Satya