There are limits to what can be achieved with Revit schedules that prevent creation of some common area schedules.
You can not:
Compare values or totals in one schedule with values or totals in another schedule.
Compare the total of a parameter with the total of another parameter.
Compare the values of a parameter with the total of another parameter.
So, for example, it is not possible to:
Create % gross area of site area
Create % nett area of gross area.
Create % greenstar area of nett area.
But you can:
Show % of an area parameter compared to the total of that parameter per floor:
(create a Calculated Value parameter, choose Percentage, and select By Level).
Show % of an area parameter compared to the grand total of that parameter (for whole building):
(create a Calculated Value parameter, choose Percentage, and select By <Grand total>).
Create totals for specific types of areas:
(add a Yes/No shared parameter and create a Calculated Value parameter using the Yes/No parameter).
The workaround is to maunally calculate the values and use text in the sheet view.