Category: Pivot Table

excel diagnostic report http://blog.contextures.com/ 0

Excel Report Diagnostic Display

Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren’t showing the correct information? To help save you from wasted time and paper,...

pivot unique count 7

Unique Count in Excel Pivot Table

A pivot table can sum and count and average, and do several other functions, but so far, it doesn’t have a Unique Count (Distinct Count) function. If you’ve built a PowerPivot pivot table, you’re...