Page 1 of 1
Crosstab Average of sums
Posted: Fri Feb 09, 2024 11:18 pm
by felixfelix
I have sql view like:
item;date;amount;total price
now i need a crosstab report with moth in head and field sum(total price), sum(amount) and a thrid field like sum(total_price)/sum(amount)
Re: Crosstab Average of sums
Posted: Sat Feb 10, 2024 10:16 am
by arbei
There is no built-in feature to calulate the summary values like sum(total_price)/sum(amount)
, but since you already have sum(total_price) and sum(amount), you may use Cell_Rendered server event to do the division yourself. Use var_dump() to check the arguments of the server event first.