0 Replies Latest reply: Apr 9, 2012 8:28 PM by Catherine Ibegbu RSS

    Need help with partial sum calculation

      I have a pivot table showing six month data (3 dimensions and 2 expression). I am doing a partial sum on the month dimension. This should give me the average of 6months but the problem occurs when a month has zero/null. For example:                                                                                                       Sep   Oct Nov Dec Jan Feb

      80      65  20   15    30    0                  this instead does sum(sep....Feb)/5...                                Any idea?