Hi Marlon,
Just as you can use an Excel Workbook as a data source, you can also use an GridView View as a source as well. You just have to save the data with the View.
However, it can take a while to load a big View too - nothing comes for free.
If you want a systematic approach to this, create a View with the lowest level of detail you need. The create progressively higher summarized Views of the same data - daily, monthly, quarterly, yearly. Have a set of Views that only refresh the current month data.
Append the current month to the other tables when you want to see the whole current data set.
You might also find that processing this data from the SalesAnalysis transaction table is faster, as it is already partly normalized. Sometimes the SalesAnalysis Statistics table has the data you need, and it only contains one record for each day.
_________________________
Andrew Bates