Afternoon All,
I'm working on a modelling tool that has behind it one very large data set.
The data set is sales by product by location.
The tool only reports on one product at a time.
Having all the data and calculations and the data set in the tool makes it 35mb+ and a bit clunky.
One alternative I thought of was to use the on change function to import the relevant data each time the user switches sku's, which shouldnt take too long really..
Any thoughts? tips?
Thanks in advance Dan
I'm working on a modelling tool that has behind it one very large data set.
The data set is sales by product by location.
The tool only reports on one product at a time.
Having all the data and calculations and the data set in the tool makes it 35mb+ and a bit clunky.
One alternative I thought of was to use the on change function to import the relevant data each time the user switches sku's, which shouldnt take too long really..
Any thoughts? tips?
Thanks in advance Dan