Hi,
I have a chart containing cumulated data using this expression:
=RANGESUM(
ABOVE(
SUM({<
[Measures (Key)]={'Operating Profit (EBIT)'},
[Version single (Key)]={'Actual'},
Period,
[Year period 1]={$(vTwelveMonthRolling_All)}
>}Values)/1000000
,
0
,
RowNo()
)
)
With this dimension: [Year period 1].
My question is, how to calculate the highest and the lowest value from this chart expression within a simple text-object.
This means if my data looks like this:
| Year period 1 | Single values | Cumulated values |
| Jan 13 | 36,1 | 36,1 |
| Feb 13 | 4,2 | 40,3 |
| Mar 13 | 80,1 | 120,4 |
| Apr 13 | -68,8 | 51,6 |
| May 13 | 62,1 | 113,7 |
| Jun 13 | 67,3 | 181 |
| Jul 13 | -63,4 | 117,6 |
| Aug 13 | 88,1 | 205,7 |
| Sep 13 | -14,7 | 191 |
| Oct 13 | 97,7 | 288,7 |
| Nov 13 | -90,9 | 197,8 |
| Dec 13 | 33,1 | 230,9 |
And I would like to receive the highest value from the cumulated column (col 3): 288.7 Oct 13
Any suggestions?
