Calculation of growth

[Anonymous]

Hi all,

I have the following table:

Group	Timestamp	Anzahl_Tagessumme	?? growth
A	12:00	5	5
A	13:00	10	5
A	14:00	15	5
A	15:00	25	10
B
B

I only have the first two columns => I don't have the third one (?? growth).

Now I want to show not the sum in a diagramm - but the growth.

I tried the follwing in the diagramm:

(sum (Anzahl_Tagessumme))-((sum (Anzahl_Tagessumme)-MaxString(Anzahl_Tagessumme)))

But it doesn't work. Can u help?

Thank you!

[MK_QSL]

IF(RowNo(TOTAL) = 1, SUM(Anzahl_Tagessumme), SUM(Anzahl_Tagessumme)-Above(SUM(Anzahl_Tagessumme)))

[effinty2112]

Hi Robert,

                    The Above function is what you need:

Timestamp	sum(Anzahl_Tagessumme)	sum(Anzahl_Tagessumme)- above(sum(Anzahl_Tagessumme))
	55
12:00	5
13:00	10	5
14:00	15	5
15:00	25	10

Cheers

Andrew

[Anonymous]

the table is not sorted and there are two different categories. I will add in the table.

[Anonymous]

the table is not sorted and there are two different categories. I will add in the table.

[MK_QSL]

Without sorting you have to calculate it at back end.

[sunny_talwar]

How about using a Aggr() for sorting here? Hopefully the Timestamp is sorted in ascending order in the script. If it is not, then it will be an issue

Aggr(

If(RowNo() = 1, SUM(Anzahl_Tagessumme), SUM(Anzahl_Tagessumme)-Above(SUM(Anzahl_Tagessumme)))

,Group, Timestamp)