Creating Dashboard with Excel. ISYS 650. Pivot Table Demo. Creating a query from Northwind data warehouse that shows: OrderYear, Quarter, CategoryID, Sales Then download to Excel and create a pivot table and pivot chart to analyze sales based on OrderYear, Quarter and CategoryID.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Creating Dashboard with Excel
Local Management Database
Note 1: Allow uer to enter category and year.
Note 2: Modify the generated GetPivotData function to reference the cells with entered category and year: =GETPIVOTDATA("Sum of ActualSales",$A$3,"OrderYear",B20,"CategoryID",B19)
Excel’s Activex Controls
Private Sub OptionButton1_Change()
If OptionButton2 Then
ListBox1.BoundColumn = 3
ListBox1.BoundColumn = 2
. What if P4 is entered in B1?
. To do an Exact Match look up:
VLookUp(SearchValue, TableRange, TableColumn#, False)