The inability to do quick pivot reports from within the database view is not merely an inconvenience but a loss of functionality that hampers productivity. Exporting data to create a pivot in Excel adds extra steps when working with dynamic data or just experimenting.