PivotTables remain one of Excel’s most powerful tools for quick data analysis, but they’re not always the perfect fit.