Get startedGet started for free

Calculated fields in PivotTables

In this exercise, you will use Calculated Fields to analyze the Sales Amount to see if the data aligns with expectations.

Bananas sells their platform subscriptions at various levels for different prices. Basic users enjoy a "freemium" experience, a free product with limited use. Premium users pay $10 per license, Business users pay $25 per license, and Enterprise users negotiate their price.

In this dataset, the Number of Users is the number of people actively using the platform under the Customer ID, whereas the Licenses Bought is the total number of paid subscriptions the customer has under their account. Each Customer ID has a unique combination of Basic non-paid users or bought licenses.

If you've lost progress, open up 1_2_pivottable.xlsx from the Workbooks folder.

This exercise is part of the course

Data Analysis in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise