cross sum calc field

[kevin163]

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?

[HighAley]

Hello.

Here is a sample report template with such cross-tab.

Report.mrt

(13.07 KiB) Downloaded 194 times

Book1.csv

(136 Bytes) Downloaded 202 times

Let us know if you need any additional help.

Thank you.

[kevin163]

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

[HighAley]

Hello.

Please, use the solution from the Stimulsoft Knowledge Base.

Thank you.

[kevin163]

thanks very much!
it works!

[Andrew]

Hello,

Perfect! Have a nice day!