Tip #3

Welcome Back to our Excel Tips Series. This week’s tip has us pretty excited over here at Complete Software!

Do you need to know the number of unique item combinations in a given set of data? You’ll be happy to know that Microsoft has added distinct count of values to Pivot Tables in Excel 2013.

Here’s how to use it:

First, select any cell in the data source and click Insert -> PivotTable, as you normally would do.  You will then need to make sure the “Add this data to the Data Model” box is checked.

Next, you will build your PivotTable, inserting items into the Rows and Values areas. Once the Values Field Settings dialog box opens, you will see that you can choose to summarize data from the selected field by Distinct Count.

When you click “OK” you will now be able to see your data summarized by distinct count!

(And a tip for those who do not have Excel 2013 yet: you can do this in Excel 2010 with Power Pivot!)

If you would like to learn more about this or any Microsoft Dynamics products, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!

Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.