Is there any way to find WAC in Pivot Table?

[prasadavasare]

Hi,
The question on your EMT 777 episod where you are using sumproduct function on sp3 sheet to find out WAC....the question is.....is there any way to find WAC for each product with the help of Pivot table.

 

[Derek Brown]

Hello and welcome to The Board.
If you can explain what "EMT" is, you would have a better chance of someone being able to help you.

 

[xenou]

"Excel Magic Tricks" I think (not sure) ... from a MrExcel podcast. I haven't seen it though.

 

[prasadavasare]

Hi Derek,
EMT is Excel Magic Tricks. Can you please see the episode on you tube....you will get the better picture on question.

 

[Derek Brown]

You have posted on Bill's MrExcel website.
I suggest that you try contacting Mike Girvin through the YouTube site, in particular posting a comment/question on the Trick 777 page:
http://www.youtube.com/watch?v=vxpeEf8MYaY&playnext=1&list=PLDA6FDE9D810EB60B
The video is 36 minutes long (with 14 examples being shown) but it would be easier for someone to download the workbook (there are two files to download and one does show WAC as weighted average cost).