Need help with a pivot table which summarizes data

Hi all,

Can anyone help me with a pivot table please? I have a table which contains data of employee's asset usage. Basically I have 3 fields:
- Email: employee's email address
- Assest ID
- Assest Cost: can be null (unknown cost)

Every employee can have 1 or more asset depend on their needs.

Here is the report I want to show:

# Assets

# Users

Total assets with cost

Total assets without cost

Total cost

# Assets will be range from 1 to 5+

Currently I need to do it manually by create a Pivot table, choose Email field to be displayed, drag Asset ID field to VALUES to show Count of Asset ID, drag Cost to VALUES field and change it to SUM to view total cost.


Thanks and best regards.