5 Replies Latest reply: Jan 9, 2013 7:49 AM by Sree Nivas RSS

    Rolling sum to display in quarter

    Sree Nivas

      Hi

      I am getting the rollup  sum value for every month .In a pivot table i need to show the latest month only by quarter wise .

       

      Quarter,Month,Value

      Q1,Nov,17000

      Q1,Dec,18000

      Q1,Jan,18500

      Q2,feb,19000

      Q2,Mar,19000

       

       

      Now i want to display in this way using Pivot Table show only the latest month in Total

       

      Q1,Nov,17000

      Q1,Dec,18000

      Q1,Jan,18500

      Total     18500

      Q2,feb,19000

      Q2,Mar,19000

      Total     19000