Weekly Sales

[wireshop]

I have a database containing order data. I would like to have another table that would have:

WeeklySales

Date

right now I calculate the weekly sales figure in my sales order database. But when I export the numbers I end up with many duplicates of the same info.

The idea here is to create a table that I can use to make charts easily. Ideally in FusionCharts.

Thanks in advance for your advice

[mr_vodka]

A little more information is needed here. You can generate a report and export from that with grouped data or you can even pump it out to a temp table and then export it from that... But without more info I dont thin kwe can help more better.

[wireshop]

What I need is a table of weekly sales figures.

for example:

weeklySales::FirstDayOfWeek

WeeklySales::Sales

What I don't understand is how to pull this data from my sales order table in which I have

SalesOrders::Total

SalesOrders::OrderDate