The raw data pulled from GroupShare has been designed to make it possible to create complex reports in as many ways as possible. This means there is a trade-off between how much granularity we wanted and how much skill you need in using Excel to get what you need. It also means a huge trade-off in terms of the time it takes to download data since the application is doing some very complex lookups between tables to pull the data in a way that makes it accessible for reporting.
Simple Reporting
For very simple reports you can of course use the filtering capabilities in Excel under the Home ribbon:
You can also add columns for your own calculations, and these can often be helpful to improve the more complex reporting by manipulating the data tables in Excel before creating your reports. It can take some thought to report accurately on what you need and to ensure you are not duplicating or omitting details. A good check is always to look in GroupShare and make sure you have the simple stuff right, such as number of organisations, or projects, as a cross check.
Detail Reporting
For detailed reporting