Help to aggr a result

[#1]

Hi guys,

I'm in trouble with an aggregation.

I have a straight table with two dimension and one expression:

nominativoD	nominativoR	GAP -1
Berti Valter	Avondoglio Marco	1
Berti Valter	Beldi' Paola	0
Berti Valter	Cotto Giovanni	0
Berti Valter	Diretti Berti Valter	0
Berti Valter	Morera Maurizio	2
Berti Valter	Valperga Giovanni	0

the expression for GAP-1 is:

if(

    sum(

        if(annomese_MNG=$(vTrimAct_MNG), left(ConsAvanzata,1))

        )

    -

    sum(

        if(annomese_MNG=$(vTrimPrec_MNG), left(ConsAvanzata,1))

        )

    =-1

,

    1

,

    0

)

I'd like to have a table with only one dimension "nominativoD" and aggr the result of GAP-1.

In poor words I'd like to have a table like this:

nominativoD	GAP -1
Berti Valter	3

How can I change my expression to reach my goal ??

Thank you so much in advance

Giampiero

My question is in the attached image.

[#2]

Thank you so much Nirmal Raj.

It works fine.

Best regards

Giampiero