PROBLEM EXCLUDING VALUES

[#1]

Hi there,

I am using the following expressions in a chart:

Label:

MaxString({<GFKBrand={"=rank(total sum({$<GFKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue))=2"}>}GFKBrand)

Value Definition:

=sum({<GFKBrand={"=rank(total sum({$<GfKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue))=2"}>}GFKValue)
/Sum(Total <YearMnth> GFKValue)

The label seems to work perfectly (2nd ranking value excluding the brands referenced, but the value expression seems to ignore the exclusion in the set analysis.

Any ideas?

Thanks!

[CELAMBARASAN]

Hi,

     I think the value expression should be something like this

=sum({<GFKBrand={"=rank(Aggr(sum({$<GfKBrand-={'BREVILLE','KAMBROOK','SUNBEAM','<TRADEBRAND & EXCLUSIVE>'}>} GFKValue),GFKBrand))=2"}>}GFKValue)
/Sum(Total <YearMnth> GFKValue)

Try it.

Celambarasan

[#3]

Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.

[#4]

Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.

[#5]

I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!

[#6 · Accepted solution]

I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!