Microsoft Dynamics GP - Excel Power Pivot SOP Dashboard (with video)

This is part 3 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

In the following video, I create a Dashboard the shows me the following information:

1. Top 10 Customers by Sales
2. Top 10 Items by Sales
3. Top 10 Items by Quantity
4. Customer Balance

The three top 10 widgets can be displayed by posted, unposted, by document type, by date range, period, quarter, week year or day.  This video was created in Excel 2013 Professional Plus.

Download Victoria Yudin's view from her blog post by clicking the link below:

SQL view with all SOP line items in Microsoft Dynamics GP

Dashboard for Distribution Series:

Part 1:  Microsoft Dynamics GP - Excel AR Trial Balance

http://saci.com/blogs/belinda-the-gp-csi/bid/154096/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-video

Part 2:  Microsoft Dynamics GP - Excel AR Trial Balance with SQL 

 http://saci.com/blogs/belinda-the-gp-csi/bid/154097/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-SQL-with-video