2 Replies Latest reply: Apr 20, 2016 8:34 AM by Sunny Talwar

# Ignore selections aggr

Hi

I have a spesific KPI that requires an aggr to get the right result:

sum({1< year = {'\$(vYear)'}, SomeDimension= {1}>} numberSomething)

/

sum({1< year = {'\$(vYear)'}>} aggr(

if(year = \$(vYear),

numberSomething)

,numberSomething,Dimension1,Dimension2,Dimension3))

But this wont ignore all selections the way i want.

Do anyone have any idea how to do this?

• ###### Re: Ignore selections aggr

May be this:

Sum({1< year = {'\$(vYear)'}, SomeDimension= {1}>} numberSomething)

/

Sum({1< year = {'\$(vYear)'}>} Aggr(

If(Only({1} year) = \$(vYear), numberSomething), numberSomething,Dimension1,Dimension2,Dimension3))

or

Sum({1< year = {'\$(vYear)'}, SomeDimension= {1}>} numberSomething)

/

Sum({1< year = {'\$(vYear)'}>} Aggr(

Only({1} If(year = \$(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))

or

Sum({1< year = {'\$(vYear)'}, SomeDimension= {1}>} numberSomething)

/

Sum({1< year = {'\$(vYear)'}>} Aggr(

Only({1} If(Only({1} year) = \$(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))