04-19-2013 07:28 AM
I know... I can get sales reports and see it in the Dashboard, but how you can in ACT! compare these with my monthly OR daily sales budget that each seller? How can I enter a sales budget in ACT! ??
04-22-2013 10:09 AM
Thanks, I really was looking for an internal functionality to enter a Sales Budget and Daily assessment regarding my Sales results, so thanks for your help.
Best Regards.
04-20-2013 06:22 PM
If you are comfortable using Excel, you could analyse your data within Excel. One very quick and easy way is to use the 1-click to excel button. A more complex way is to utilise the OLEDB2 provider as a data source for Excel.
Ecel will give you more power to slice and dice your data. If you have Excel 2010 or 2013, you could consider using PowerPivot if you know of those free MS add-ons for Excel.
04-22-2013 09:32 AM
Some time back I created a report for a client with similar requirements. They wanted a monthly analysis for sales against quota with accumulations for the year. As I recall without digging out the report template i used an opportunity for each user that had a stage the was dedicated to their quotas. Needless to say it took significant VB scripting to make the reprot work (over 700 line of code). However it took an analysis that was taking over a full day to do and reduced it to about 5-minutes to get the report.
04-22-2013 10:09 AM
Thanks, I really was looking for an internal functionality to enter a Sales Budget and Daily assessment regarding my Sales results, so thanks for your help.
Best Regards.