Thanks for reading! Yes, you can certainly calculate the average. You have to go in the Field Wells -> Value field. Click on the value field and change the aggregate to average instead of sum.

In the example in this post, there are no multiple values per category, hence the sum and average would be same per category.

I hope that helps! Cheers!