Why can't have total for all Dimensionality ?

[Anonymous]

Hi everybody,

why in this pivot table can't have total of    rangesum(above(total sum(Sales), 0, rowno(Total)))

for all the Dimensionality  ?

Thanks in advance to those who will want to help

Andrea

[kuba_michalik]

That's because rowno() returns null for summary rows, so the formula is summing over empty range in those rows (I think)

[Anonymous]

Kuba,

thanks for the answer, but then how do
to have the totals of all Dimensionality ? is there a way?

Thank