Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all.
is there a way to use dimension limits to create a sub total, without it subtotaling an expression that is displayed as a sparkline?
I want to sub total my straight table, but one of the expressions is a spark line chart that shouldn't be sub totaled.
with a sub total:
Without a sub total it displays perfectly:
is it possible to sub total all my expressions bar the sparkline?
thanks in advance!
hi
try to warp your expression with Dimensionality function
for example :
if(Dimensionality()>1, sum([Sales]))
hi
try to warp your expression with Dimensionality function
for example :
if(Dimensionality()>1, sum([Sales]))
brilliant! works a treat!
thanks a million!