5 Replies Latest reply: May 26, 2016 7:18 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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 :-






      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.