4 Replies Latest reply: Nov 24, 2012 4:27 PM by ann 2012 RSS

    Add 'Totals' as a graph header

    ann 2012
      Hi,

      I am displaying 'sales' by 'zone' on my graph.

      Example:

      zones sales

      a 10
      b 10
      c 20
      d 20
      e 20

      Is it possible to show Total : 80 as a graph header.

      If i am grouping the zones then it appears as a new axis on the graph. I don't want the 'total' to appear as an axis . I want to appear it as a header just below the graph title.

      Is it possible??

      Any help would be greatly appreciated!!!!

      Thanks!!!
        • 1. Re: Add 'Totals' as a graph header
          MuRam
          Hi,

          Hope this is not possible.
          Please create a separate column to show the summed up values of the column, remove the title of the graph. Now create a narrative view with the title of the graph and below it use @column_position_number to show the summed up value.

          Hope this helped/ answered.

          Regards
          MuRam
          • 2. Re: Add 'Totals' as a graph header
            MuRam
            Hi,

            Hope this is not possible.
            Please create a separate column to show the summed up values of the column, remove the title of the graph. Now create a narrative view with the title of the graph and below it use @column_position_number to show the summed up value.

            Hope this helped/ answered.

            Regards
            MuRam
            • 3. Re: Add 'Totals' as a graph header
              ann 2012
              Thanks for your response!!!

              however , i am struggling with this step - ' create a separate column to show the summed up values of the column'

              Can you please help me with that.

              My criteria currently has these two columns:
              zone,sales

              Once again thanks for helping me.
              • 4. Re: Add 'Totals' as a graph header
                ann 2012
                ok. I applied SUM () in my expression.

                SUM ("Gross Sales"." Gross Sales Amt" )

                This created a column that has grand total. Then I just pulled first row in my narrative view to display the total.

                This worked.

                Thanks again for all your help!!!!