use total sum in Pivot

[#1]

Hello Guys,

I hope you can help me.

how can i use the red marked field in my expression:

if(red_field>0,sum(value))

(gesamt=total)

Kind Regards,

Lukas

[swuehl]

Lukas,

it looks like you are using four dimensions and one expression, right?

So if you expression looks like

=sum( ExpressionValue)

then try

=sum(TOTAL ExpressionValue)

to retrieve the overall total value (I assume that is your Gesamt value outlined in red).

Then try

= if(sum(TOTAL ExpressionValue) >0, sum( AnotherValue))

Hope this helps,

Stefan

[#3]

hi Stefan,

i think my example is not so good, here another example.

Its not always the Total value.

I've tried something with dimensionality ( ) = 1 but it also doesn't work.

any ideas?

[swuehl · Accepted solution]

Try TOTAL qualifier with field / dimension list:

=sum(TOTAL<Dimension1> ExpressionValue)

(or specify all the Dimensions you need to consider for your total sum, sum(TOTAL<Dimension1, Dimension2> ExpressionValue) )

But this will only return the total in the same context of Dimension1, i.e. you can't refer the same subtotal for all lines (lines that belong do different Dimension1 values). Do you need something like this?

[#5]

thank you 🙂

now it works.