8 Replies Latest reply: Jun 28, 2016 10:06 AM by Mambi Badi RSS

    Total display in Bar Chart

    Mambi Badi

      Hello everyone,

      i'm using QV 8.5 and i want to display my bar chart as the image below ;

      my expression is sum(QTE) / sum(total <CAT, YEAR> QTE)  ( to display the percentage inside each segment )

      All i want to do is to display the total (not in percentage) next to each bar ( for exemple : 2016 -> category 1 the sum of all quantities is 125....)

      here's the data :

      LOAD * INLINE [
           CAT, PROD, QTE, YEAR
           category 1, prod 1, 10, 2015
           category 1, prod 1, 34, 2016
           category 1, prod 2, 20, 2015
           category 1, prod 2, 59, 2016
           category 1, prod 3, 32, 2016
           category 1, prod 3, 70, 2015
           category 2, prod 1, 11, 2016
           category 2, prod 1, 30, 2015
           category 2, prod 2, 15, 2016
           category 2, prod 2, 30, 2015
      ];

      i know that's in QV11 there's the option "still show the total on top" but it's display 100% and it's not available in QV 8.5


      any idea how  to achieve this task ?