Is Total mode for expressions possible in Pivot tables?

[#1]

From time to time I use AVG of rows in total mode for straight table, but that option isn't available in Pivot table.. Can it somehow become possible?

[Anonymous · Accepted solution]

I asume yopu mean that the total expression should be different than the "line" expression. If this is correct, make your expression conditional, using, for example, dimensionality(). It may look like this:
if(dimensionality()=0, avg(...), sum(...))
(If I remember correctly, dimensionality()=0 for the tola row. Can't test now.)

[#3]

I had this same problem, dimensionality() works perfect, BUT:

- How about the total line label?? it's now 'total' but i like to have 'Average'

- Is it also possible to have 2 total lines? (one with the avg() and one with the count()??)