PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...
If you can write an Excel formula, you can build your own function.