How to use aggr function with no effect of Year and month selection

[kavita25]

Hi,

In my expression, I am using aggr function, but if I select Year and Month Filter the expression should not be changed.

Please help me to solve this issue..

Regards,

Kavita

[#2]

Use Set Analysis in the AGGR or update the sample file.

[ziadm]

Hi

Sum({<Month=,Year =>} Sales)

This should ignore the Month and Year selections

Regards

Ziad

[kavita25]

Yeah I know that....

I want to use aggr function along with the expression u gave it to me.

Regards,

Kavita

[PrashantSangle]

Hi,

On what basis you need to aggregate your existing Expression

General Syntax:

Sum(Aggr(Sum({<Month=,Year =>} Sales),Aggregated_field))

Regards

[satheshreddy]

hi,

alternative states option available in  QV11 so ,

why you can no't use that option?

thanks

s reddy

[kavita25]

How Can I use Alternate State in Straight table only for one expression???

Regards,

Kavita

[kavita25]

This doesnt work....

[PrashantSangle · Accepted solution]

Hi,

Try to nullify in Outer Sum() also

like

Sum({<Month=,Year =>} Aggr(Sum({<Month=,Year =>} Sales),Aggregated_field))

If it wont work, Please share sample apps.

Regards

[kavita25]

Thank  You Soo much....