3 Replies Latest reply: Apr 1, 2016 8:03 PM by PAUL YEO RSS

    8020 chart Display by sales ok but eXP not okay.

    PAUL YEO

      Hi All

       

       

      I have Chart 1 work fine . When i select measure = sales. The expression as below :-

       

       

      if(Num(Rank(sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}sales/$(Columndim89))

      /

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL <$(ColumnDim_p)

      > sales/$(Columndim89))))<=15,sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      sales/$(Columndim89))

      /

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      TOTAL <$(ColumnDim_p)

      > sales/$(Columndim89))),

       

       

      When i select meansure = eXP ( By click on step 2 ) , My expression now working.

       

       

      The differeent between sales and eXP are :-

       

       

      For sales = sales , But for eXP = Sum({<eXP={"eXP"}>}Amount)

       

       

      My question is how to replace sales to eXP to above expression ?

       

       

      Paul