Dimension Limits and Sparklines

[wonkymeister]

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!

[lironbaram · Accepted solution]

hi

try to warp your expression with Dimensionality function

for example :

if(Dimensionality()>1, sum([Sales]))

[wonkymeister]

brilliant! works a treat!

thanks a million!