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.

[Anonymous]

   use this expression in chart

aggr(if(sum(if(annomese_MNG=$(vTrimAct_MNG), left(ConsAvanzata,1))  - sum(if(annomese_MNG=$(vTrimPrec_MNG), left(ConsAvanzata,1)))=-1,1,0)  ,  nominativoD )

add only single dimension nominativoD

Regards,

anant

[Gysbert_Wassenaar]

Try

sum(aggr(

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

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

    1,

    0),nominativoRM))

[#4]

Hi,

Can you please Upload your Application. I will try to solve.

Regards,

Nirmal Raj.

[#5]

Hi guys,

first of all THANKS to reply.

@ Anant  and Gysbert: Unfortunately it doesn't work. The result is 1 and not 3

@ Nirmal Raj: Unfortunately My Qvw is to big and I can't put it on internet. I'll try to create a Qvw similar.

Any other idea ??

I'm really in trouble. I have to show the result today and I don't know how to solve this problem.

THANK YOU SO MUCH

Giampiero

[#6]

Atleast upload simple sample application.

[#7]

Hi,

I attach a simple application.

Hope it helps.

Thanks all.

Giampiero

[#8]

Hi,

Please Find The Attachment hope problem is solved.

Regards,

Nirmal Raj.

[#9]

Hi,

I Hope This is Exact Output you need.

Regards,

K.J.Nirmal Raj.

[#10 · Accepted solution]

Hi,

See this Attched File...........hope your needful has been done.

Regards,

Nirmal Raj.