Visualizing values from various charts in one sheet object

[#1]

Hi Guys,

can somebody help me, please.

In my management cockpit I want to show relevant results (values) from 8 different charts in one sheet object as an overview.

Maybe the following example can help you to understand my intention:

A first linechart shows the development of the KPI "ROI" from 2005 till 2012

A second linechart shows the development of the KPI "ROCE" from 2005 till 2012

A third ...

Now, what I want is to show the current value of "ROI" (current value = 55,47%) and "ROCE" (current value = 51,11%) from 2012 in one sheet object together. In addition it has to flexible no static string visualisation of the current values. That has to meant that a change to the values of the charts has to implised changes to the values of the sheet objects, too.

Is that possible? How can I do it?

Thanks in advance.

Greetings,

laju1014

[Jason_Michaelides]

You could use Aggr() and FirstSortedValue() in a text object for this, I think.

Let's say your chart 1 had Date as the dimension and Sum(ROI) as the expression.  You first textbox could have:

=FirstSortedValue(Aggr(Sum(ROI),Date),-Date)

Hope this helps,

Jason