Pivot table percentage of number of rows

[Ruca13]

Hello experts,

I have a data representing the purchases of each customer per category.

Customer	Category Food	Category Clothing	Category Electronics
John	Bananas	Hat	Laptop
David	Meat	Jacket
Peter		Tshirt	Headphones
Andre	Fish	Jeans

I would like to have a pivot table to show how much each category represents over the total customers.

I am able to do it with formulas, but not with the pivot.

=COUNTA(B2:B5)/COUNTA($A$2:$A$5)

This is the expected output:

Category Food	Category Clothing	Category Electronics
75%	100%	50%

The data can have helper columns if needed.

Thanks in advance.

Best regards,
Rui