This discussion is archived
4 Replies Latest reply: Nov 24, 2012 2:27 PM by ann 2012 RSS

Add 'Totals' as a graph header

ann 2012 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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!!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points