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,

      Royce