The below is a working example of how you can use a pivot table to pull back geology data you require. In the working example below the template shows the pivot table displaying which geology layers lie over others.
To Load this report select the Load button from the "Reports Selection Window" within the Excel Extension and then select the file downloaded using the link below.
Please contact the support team and request for the 'GeologyLayerOrderwithPivotTables.xlsm' file.