We have a number of trended graphs showing a rolling 12 months of current/prior/budget data.

A user has asked if there was a way they could see the TOTALS for the period in some fashion....as opposed to adding up the individual bars.

I suppose we could create an extra 'month' in the data that houses the total but that could throw off the scaling and is a bit of work.

Another thought was to place some verbiage on the graph and when you clicked it would call a fex showing the totals. I see no way of doing this though...

Perhaps there is something even simpler?

This message has been edited. Last edited by: <Kathryn Henning>,

Adding the totals as part of the Header, Sub Head or Footing could also be an option.

can you elaborate? Are you suggesting I can put text, say: 'Click for Grand Totals' in the GRAPH Header, and have that drill to a fex t hat shows the total? How do I enable the drill for the text...via the GUI or must you somehow do it in the code?

Try this

TABLE FILE DEMO
SUM
DOLLARS
BY CATEGORY
HEADING
"Total= END

???
I need to have a link on my graph that will drill to something that pops up the grand total of the 12 trended bars shown...unless there is away for the graph to do this via some setting...