Creating reports and dashboards | Stimulsoft community forum

i have a cross table report.
the cross row is product item,the cross column is date.the cross sum value is the product qty and amount.
i need to calc the item's average price.like sum(amount)/sum(qty)

the format like this
product name date
qty price amount
2014-09 2014-10
product1 100 100 10000 110 100 11000

my data like this
product name date qty amount
product1 2014-09 50 5500
product1 2014-09 50 4500
product1 2014-10 100 10000
product1 2014-10 10 1000


how should i get the price in the cross table?

Hello.

Here is a sample report template with such cross-tab. Let us know if you need any additional help.

Thank you.

thanks for reply.
i want to show the average price in the cross table.
average price = sum(amount) / sum(qty)

the result format and calc format see the attachment book1.xls

Hello.

Please, use the solution from the Stimulsoft Knowledge Base.

Thank you.

thanks very much!
it works!

Hello,

Perfect! Have a nice day!