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.