Sum row in chart

Question: Hi all,

does anyone know if and how is it possible to display only the sum row of a key figure in a chart (e.g. tachometer). I have for example 10 rows of data for 5 orders (delays) as below:
Order 1 10min
Order 2 12min
Order 3 15min
Order 4 5min
Order 5 7min

and the sum of them is 49min. I want to display a tachometer chart with only value 49min in it without displaying the rest detailed values.
Is it possible?How?

Answer:
I would just remove the drill-down by Order. That should leave you with just the sum displayed, so that is what will be shown on the graph.

Hope this helps...

Bob

Answer:
Thanks very much for your reply Bob.

Unfortunatelly I cannot remove the drill-down, as I use some of the keyfigures to calculate a KPI per order, and then display the sum of the individual KPIs (as "sum of all values").

If I remove the order, the sum will not be calculated correctly.

Is there a way to display only the arrow for the total in the tachometer?

Thanks in advance,
Sakis
Copyright ?2007 - 2008 www.jt77.com