Category Archives: PowerPivot

Count Unique Items in Pivot Table With Excel 2013 PowerPivot

Last year, I described how to create a unique count in an Excel 2010 pivot table, by using the PowerPivot add-in. In that version, you can right-click on the table name in the field list, to add a new measure. … Continue reading

Posted in PowerPivot | 8 Comments

Unique Count in Excel Pivot Table With PowerPivot

In Excel, this is no built-in summary function that calculates a distinct count or unique count. In the pivot table shown below, we’d like to see the number of stores in Boston, where each product category was sold. Instead of … Continue reading

Posted in PowerPivot | 20 Comments

Special Price Today on Microsoft PowerPivot Ebook

If you’re interested in learning how to use Microsoft PowerPivot for Excel 2010, there’s a special price today on the ebook version of Microsoft PowerPivot for Excel 2010: Give Your Data Meaning, by Mark Russo and Alberto Ferrari. Here’s the … Continue reading

Posted in PowerPivot | Leave a comment

PowerPivot Contest

If you love the new PowerPivot add-in for Excel 2010, you can enter the latest contest on the PowerPivotPro blog. Show off your efficient PowerPivot techniques, and win one of the two top prizes — a 1 year MSDN subscription. … Continue reading

Posted in PowerPivot | Leave a comment

PowerPivot For Excel 2010

Microsoft PowerPivot for Excel 2010 is a data analysis add-in for Excel 2010, and is part of the Office 2010 Beta. You can test PowerPivot in the hands-on Virtual Lab, or in the Office 2010 Beta, if you’ve downloaded that. … Continue reading

Posted in PowerPivot | Leave a comment