Hello Andrew,

You got me excited there. I see that you can use a view as a source but it has to have the data first save before you can further use it on another view as a source. So if I update the Primary View (source) I have to save it first before I open the second view. As you have mention, it similar to your Excel Direct suggestion earlier on this post.

Anyway, thank you.

Yes, I notice that if I use the Sales Analysis data, it is much faster.

Marlon

Support,

It is similar to what Andrew suggestion (ExcelDirect) earlier this post but instead of excel, you use the views with save data in it.

Thank you.

Marlon

Marlon:

To speed up the process I would recommend reducing the number of years history you have stored. Very rarely do users need to report on data more than 3 years old.

So that you don't lose the data, make a copy of your database before doing the purge. If you need to look up older data then you can access the copy.