Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!
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
Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.
Didn't work unfortunately - it is picking Sunbeam as 2nd brand even though I want it excluded. But it works in Label expression.
I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!
I found the problme (after a good nights sleep!). I was simpley referencing the field incorrectly ('GfKBrand' - should have been 'GFKBrand'. Doh!