Crosstab Average of sums

[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)

[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.