add my own formula to pivot table

[irishtrash]

Hi all I was hoping someone here might be able to help me out with a pivot table I'm trying to make. what I want to do is add all the totals of the individual codes weights together and then divide it by the total by the total then multiply it by the fat.
an example from the spread sheet I have attached would be adding all of the code 3's together which gives me 1828. then we take the weight 515 and divide it by the total which gives me 0.2817287 then multiply that by the fat % which in this case is 32.2% which gives me the result 0.447237724685498....
I hope I have explained myself properly there is another step after this but I think I'm ok with that step.
Thanks in advance for any help

[:) Sixthsense :)]

Hi irishtrash,

Welcome to the forum

Check Calculated Field option in Pivot Table.

[VKS]

Hi, Welcome to the forum.
If you multiply 32.2 (As shown in the column without % sign) with 0.281..... you will get 9.07.... not 0.447 as you mentioned. how are you getting 0.44 please advise.
Best Regards/VKS

[irishtrash]

I got that result from staring at the screen too long and my eyes going blury!! I made a mistake in that calculation.
The calculated field option would work for me if it would let me select fields/cells from the original file when setting it up.

I'm going to be getting these reports everyday so hoping to make it automated as in I'm looking to drop the up to date details in and refresh it and hey presto
so looking for it to pull the original weight of each individual code and divide the total of that individual code into each line weight of that code....

Pretty much I'm looking to work out the weighted average of fat % in each line using the total weight of that code used on any giving day.

Thanks for advice and reply's

[VKS]

Have done some modifications to your pivot table.
Please check the attachment and let me know if this is what you want.
Best Regards/VKS

[irishtrash]

Thanks for that VKS I have re-attached a the file some of the math is working out different to my calculations (I have just used product code 3 to show) .

[VKS]

Hie, It was my mistake in column F formula. Please check the attached.
Best Regards/VKS