19 Replies Latest reply: Feb 15, 2017 4:15 AM by Royce Tang RSS

    Duplicate values in bar Chart

    Royce Tang

      Dear experts,


      I am trying to create a bar chart with 2 dimensions, however I am ending up with duplicate values,


      the expressions are as follows:

      Bar chart .. Sum(cash)

      line graph .. Sum({$<BDF_Type={"*profit*"}, YEAR = {'2015'} >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR = {'2015'} >} cash)


      I have attached screen shot for your reference.


      Kind regards,