Show me the steps to solve Build the Percentage Text Table

Your manager would like you to convert the Commercial Units and Residential Units fields into percentages. The hope is that this will help describe the percentage of total units sold per group, allowing the acquisitions team to make informed decisions about the type of property to look for $($commercial or residential$)$ and in which borough. The visual should display this information as a text table.

Create a new worksheet.

Create two calculated fields.

These fields are:

$$ Percentage of Commercial Units

$$ Percentage of Residential Units

To do this, you'll need to:

$$ Divide Commercial Units by Total Units

$$ Divide Residential Units by Total Units

For these two fields, make sure you use the SUM aggregation in the calculated fields.

Tip

When using aggregate functions $($e$.$g$.,$ SUM$),$ the syntax is as follows:

SUM$([$Field$])$