Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thanks! really helpful