3 Replies Latest reply: May 25, 2016 7:53 AM by PAUL YEO RSS

    aggr(sum(total <$(ColumnDim_p)> sales) How to replace with rEVENUE ?

    PAUL YEO

      Hi All

      I have expression as below work fine for chart 1:-

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

       

       

      I also have expression below work fine for chart 2 :-

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

       

       

      when user select Dim2 = rEVENUE , I have convert the above expression to below , and this expression i insert at Chart 3 :-

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} rEVENUE={rEVENUE}>}Amount/1000/$(Columndim89))

       

       

      Chart 3 Dimension expression as below :-

      =if(aggr(sum(sales),$(ColumnDim101)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim101)) > 0.00001, $(ColumnDim101), ' Other')

       

      Can some one advise me how to change the above expression sales to rEVENUE ?

       

       

      So that chart 3 is able to display the bar.

       

       

      Paul