How to add a calculated field in pivot table with a Count ? formula

[StrawberryDreams]

How can I add a calculated field to the pivot table that takes the sum of each category [( bud, flower, berry etc.) as organized by date and plant code row,] and divides it by the count of each unique plant code by date as shown in the example next to the pivot table ?

PLANT TYPE CODE	Bud	Flower	BERRY	DATE
A	3	1	2	11-Mar
A	3	2	1	11-Mar
B	1	0	1	12-Mar
B	5	0	4	12-Mar
E	8	2	4	15-Mar
B	0	1	4	14-Mar
E	2	0	4	15-Mar
B	3	1	4	11-Mar
E	2	4	2	11-Mar
E	1	1	1	11-Mar

Row Labels	Sum of Bud	Sum of Flower	Sum of BERRY		BUDS PER PLANT CODE	FLOWERS PER PLANT CODE	BERRY PER PLANT CODE
11-Mar	12	9	10
A	6	3	3	A	6/2 = 3	3/2 =1.5	3/2 = 1.5
B	3	1	4
E	3	5	3
12-Mar	6	0	5
B	6	0	5
14-Mar	0	1	4
B	0	1	4
15-Mar	10	2	8
E	10	2	8
Grand Total	28	12	27

 

[StrawberryDreams]

Is this possible to do without VBA as well , since It needs to be mobile compatible ?

 

[StrawberryDreams]

Crickets ***

I’m still learning basics in excel so any help is appreciated. Would this require using a thing called Measures in the pivot table ?