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?