5 Replies Latest reply: May 26, 2016 7:18 PM by PAUL YEO RSS

    My Dimension Expression error unable to make all my Bar same height.

    PAUL YEO

      Hi All

       

       

      I have a Bar Chart which display Expense by year stack with different expense type.

       

       

      I want to make the Bar same height . So that i can view the % contribution by expense type.

       

       

      My expression as below is okay :-

       

       

      Sum({<eXP={eXP}>}Amount/1000)

       

       

      My issue is I try the below but it does not work, mostly likely is the area i mark red :-

       

       

      =if(aggr(sum({<eXP={eXP}>}Amount*-1),$(ColumnDim101)) / aggr(sum(total <$(ColumnDim_p)> {<eXP={eXP}>}Amount*-1), $(ColumnDim101)) > 0.001, $(ColumnDim101), 'OTHERS')

       

       

      Now the chart is display the total expense by year. Hope some one can share with me.

       

       

       

       

      PAul