3 Replies Latest reply: Jul 28, 2009 10:42 AM by Matt Sweeney RSS

    Sum in Pivot Table using Set Analysis

      Hi Guys,

      Yes, yet another question about set analysis and pivot tables - this time i want to show the sum of all values in a column.

      This is my formula:

      =If(GLLedger = 'N',Sum({$<Month =>} If(InYearToDate(GLTranDate, vMaxDate, 0, 7), GLTranAmount)))

      This sums at partial sum levels but not as a grand total. I've tried to re-arrange the formula to nest the IF statement inside the Sum statement, but this does not work.

      I look forward to reading Oleg's post about Flags which would presumably solve this, but is there a simpler and easier way?