Question on Pivot Table partial sum

[#1]

Hi,

Is it possible in pivot table, to have the expression as text (Ex: minstring(Column)), but the partial sum should be a number (ex: Sum(Column5) * Sum(Column6)). I understand that it is possible to have text as partial sum when text is used in the expression as well, but is it possible to use own expression for partial sum only.

.
Is it possible to achive the above requirement in Pivot table.

Thanks.

[swuehl]

You could use the functions dimensionality() and secondarydimensionality() to check if the expression is evaluated for a row or a partial sum.

It could look similar to

=if(dimensionality()=0, Sum(X)*sum(Y), minstring(Z) )

The exact value to compare dimensionality() with will depend on the dimension level you are referring to.

Please see also the examples in the Help file.

Hope this helps,

Stefan