Is it possible to insert an expression just for Totals and keep values as they are?

[MEBG93]

Hello experts,

Is it possible to insert an expression just for the Totals row whilst keeping the original values in a measure on a Pivot Table?

Many thanks!

[dplr-rn · Accepted solution]

Yes. use dimensionality function

so instead of totals you wanted count. use  if(Dimensionality()=1,count(OrderID), Sum(LineSalesAmount))

also to identify the dimensionality you want. use Dimensionality() as a measure

use this for reference.

https://community.qlik.com/t5/QlikView-Documents/How-to-use-Dimensionality/ta-p/1485559

[MEBG93]

Thanks! really helpful