6 Replies Latest reply: Oct 7, 2016 7:22 AM by Sunny Talwar

# Calculation of growth

Hi all,

I have the following table:

GroupTimestampAnzahl_Tagessumme?? growth

A

12:00

55
A13:0010

5

A14:00155
A15:002510
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!

• ###### Re: Calculation of growth

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

• ###### Re: Calculation of growth

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

• ###### Re: Calculation of growth

Without sorting you have to calculate it at back end.

• ###### Re: Calculation of growth

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)

• ###### Re: Calculation of growth

Hi Robert,

The Above function is what you need:

Timestamp sum(Anzahl_Tagessumme) sum(Anzahl_Tagessumme)- above(sum(Anzahl_Tagessumme))
55
12:005
13:00105
14:00155
15:002510

Cheers

Andrew

• ###### Re: Calculation of growth

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