Efficient way to not show expression if sum(expression)=0

[praijmakers]

Hello All,

I have a Chart Table with +40 expressions. Below an example (A to F are expressions)

Now i would like to hide the expression where the sum over all months is 0.

Each expression is like this (with offcourse different FKcodes per expression):

sum({<FKcode={'VD1'}, Bron = {'result'}>} amount)

and in the conditional for each individual expression i could set this (it also includes a variable vShowZero)

sum({<FKcode={'VD1'}, Bron = {'result'}>} amount) >0 or vShowZero = 1

Now I'm getting a performance issue with this table because I'm basically doubling each expression just for the conditional show determination.

Can this be done more efficiently??

Your help would be appreciated.

Regards,

Peter