5 Replies Latest reply: Mar 9, 2012 5:41 PM by danielgrahame RSS

    PROBLEM EXCLUDING VALUES

      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!