What could be the reason for this discrepancy?

An implementation engineer has been asked by a client for assistance with the following problem:

The below dataset was ingested:

However, when performing QA and querying a pivot table with Campaign Category and Clicks, the value for Type’ is 4.

What could be the reason for this discrepancy?
A . The measurement ‘Clicks’ is set as a percentage.
B . A mapping formula was populated, indicating not to bring Type! values.
C . The aggregation function is set as AVG
D . The aggregation function is set as LIFETIME

Answer: C