Problem of cumul in a graph

[#1]

HI,

I have a problem doing a graph, I join an example, it is related to a condition about showing or not lines depending of the total amount (it has to be greater than a value in a variable (seuil in the example).

I cannot managed the condition sum(Amoun)>seuil at the right level in the graph...well better to lokk at the example. Hope it's clear enought.

[#2]

Hi,

You need to use the function AGGR();

Expression:

Visa: SUM(IF(Aggr(sum(if(Genre='Visa',Amount)), Section, Nom) > seuil, Aggr(sum(if(Genre='Visa',Amount)), Section, Nom) ) )
Travel: SUM(IF(Aggr(sum(if(Genre='Travel',Amount)), Section, Nom) > seuil, Aggr(sum(if(Genre='Travel',Amount)), Section, Nom) ) )
Cash: SUM(IF(Aggr(sum(if(Genre='Cash',Amount)), Section, Nom) > seuil, Aggr(sum(if(Genre='Cash',Amount)), Section, Nom) ) )
Total: SUM(IF(Aggr(sum(Amount), Section, Nom) > seuil, Aggr(sum(Amount), Section, Nom) ) )