Pivot Table formula giving incorrect results

Originally Posted by VKS

Hello Evil,
Welcome to the forum.
You are getting the wrong totals because Pivot Table is adding up your rates and then multiplying it with length.
You may have to tweak in your source data!!
Best Regards/VKS

And thats how I went about fixing it.... so what I had to do was go right back to my original SQL query to add a field to my source date, so it was multiplying my Unit Rate * Length, then go about it that way, as the pivot wasnt doing what I thought it was.

Thanks for your help. Problem Solved!