Aggregating The Tables #įirst we will need to aggregate the data to the customer and product level so that we can compare the two tables. If you’re running Excel 2016 then it’s already installed and can be found in the Data tab of the ribbon. Find out how to install Power Query here. Get & Transform was previously called Power Query in Excel 20, and you will need to install is as an add-in. Get & Transform will allow us aggregate these tables to the same level of granularity and join the aggregated data by their common dimensions to easily find the differences. There are several other differences in the tables, but spotting them manually will be hard and won’t scale when your tables have more data. Table A contains data for Alex but table B is missing AlexGeoff has 2 sweaters in table A but has 3 sweaters in table B

If we take a look at the data we can see some differences. We want to compare these two sets of data and find out where the differences are and quantify these differences. This table has three dimensions of customer and product, and two metrics of quantity purchased and amount paid. This table has two dimensions of customer and product, and two metrics of quantity purchased and amount paid.Table B contains data for the same clothing purchases by customer and product with an extra dimension of description and also includes quantity purchased and the total amount paid.

Table A contains data for clothing purchases by customer and product along with the quantity purchased and the total amount paid. Now you can expand the drop-down list to see whether the options are displayed correctly.In this example we have table A and table B. Hit OK to apply the Drop-Down List Properties to your document.ĩ. Note: you just need to fill in the Display Name, the textbox of Value will be filled automatically.Ĩ. Input the options you want to add in the list. Tap the Add… button in the popping out Content Control Propertieswindow.ħ. Click it, and hit Properties in Controls section under Developer tab.Ħ. Now the list has been added to the where your cursor is.ĥ. Then go to Developer tab and find Drop-down List Content Control in Controls section.Ĥ. Place your cursor at where you want to add a drop-down list. Check Developer in the list of Main Tabs (under Customize the Ribbon) to enable it, and click OK to confirm the change.ģ. If not, click File > Options, and switch to Customize Ribbonpane in Word Options.Ģ. First, have a check that if you can find Developer tab in your Word. For similar reasons, some people may also want to add a drop-down list in Word. I’ve wrote a post about creating a drop-down list in Excel before.

How to insert a table in word 2016