This content has been marked as final.
Show 6 replies

Re: Calculation of growth
Manish Kachhia Oct 7, 2016 5:39 AM (in response to Robert Ebner)IF(RowNo(TOTAL) = 1, SUM(Anzahl_Tagessumme), SUM(Anzahl_Tagessumme)Above(SUM(Anzahl_Tagessumme)))

Re: Calculation of growth
Robert Ebner Oct 7, 2016 5:50 AM (in response to Manish Kachhia )the table is not sorted and there are two different categories. I will add in the table.

Re: Calculation of growth
Manish Kachhia Oct 7, 2016 6:10 AM (in response to Robert Ebner)Without sorting you have to calculate it at back end.

Re: Calculation of growth
Sunny Talwar Oct 7, 2016 7:22 AM (in response to Robert Ebner)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
Andrew Walker Oct 7, 2016 5:43 AM (in response to Robert Ebner)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

Re: Calculation of growth
Robert Ebner Oct 7, 2016 5:50 AM (in response to Andrew Walker)the table is not sorted and there are two different categories. I will add in the table.
