DateWarehousing

jacklcs

Good day..

I have a BO show daily sales...in this BO, I have the MonthName='December 2010'

I would like to show a query this way using the Daily Sales BO.

Month..............Total Gross Amount
January 2010...... $2000
going on....
December 2010.... $5000

Can the query present this way?

Thanks......

tford

No, but you can calculate those values in the BO, then present it in the BO.

rocketman

Have you looked at the CRM sample - in particular the statistical analysis of customer contact.

The technique used is really cool and involves running an overnight schedule to clean and rebuild the current month stats. In the sample they graph the results but the query results can easily be shown as a standard list