CRMFAQ, dynamicsfaq CRMFAQ, dynamicsfaq  


home   home knowledgebase   knowledgebase technical articles   technical articles updates/hotfixes   updates/hotfixes downloads   downloads blogs   blogs add-ons   add-ons community links   community links contact   contact imprint   imprint

search for:






Is there a way to total in the views?

Does anyone know if there is there a way to total in the views (so that we can see totals (in opportunities especially) without having to run reports?

If you are using CRM V3, you can use the Live Excel feature to sum your total easily.

Here are the steps,
1. Hit export data to excel
2. Pick dynamic worksheet.
3. Save the excel file.
4. Open and modify the excel file to add a total field.

You can keep this excel file locally on your machine, or upload it to server so that everybody can see it. Note, since it contains live data, everybody can only see their own data. There is no security issue even when you upload the excel file to CRM server to share with everybody.


Andreas Donaubauer
MVP for CRM since 2005

[read more]

RSS-Feed to
Site crmfaq

Microsoft Dynamics Related Community


To order the newsletter please sign in with your e-mail adress.
To cancel the newsletter please enter your e-mail again.


last change : 2013-09-23

Notes, suggestions or questions see "contact". All information is without guarantee! Names and product designations can be property of the respective manufacturers.
(C) 2004 - today by Andreas Donaubauer. Each further publication only with my previous agreement.