How to use a subtotal in a new expression

[#1]

Hi everyone,

y want to use the subtotal in a new expression like this...

TMCausa= sum({<PLANTA={'Malabrigo'} >}CANTABS)

[vishsaggi · Accepted solution]

Did you try this:

= sum({<PLANTA={'Malabrigo'} >}CANTABS)/sum(Total {<PLANTA={'Malabrigo'} >}CANTABS)

IF not can you share a sample app that depicts the data above?

Thanks,

V.

[sunny_talwar]

Or this if the total needs to change based on different ORIGEN:

=Sum({<PLANTA={'Malabrigo'}>}CANTABS)/Sum(TOTAL <ORIGEN> {<PLANTA={'Malabrigo'}>}CANTABS)