Which environment are you working on?
A possibility is to use PivotTables in Excel, either based directly on the SQL relation engine, or on an SSAS cube or on a PowerPivot model.
If you have SQL Server 2012, you could also think about using PowerView.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP