3 Replies Latest reply: Mar 29, 2016 7:05 PM by PAUL YEO RSS

    My chart 2016 bar display when i select compute eXP

    PAUL YEO

      Hi All

       

       

      I have a CHART 1 , when i click on display in Org or S$ currency , the CHART able to display summary total SALES amount FOR ONE COMPANY OR ALL COMPANY.

      The minute when user select the compute by eXP , the overall total amount disappear FOR 2016.

       

       

      I try to modify the expression using Chart 2 by add Aggr  as below :-

      Sum(Aggr(Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)*-1/1000, $(ColumnDim101))),

       

       

      But not working.

       

       

      I expect chart to display 600K , which is same as Table 1.

       

       

      Paul