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