I have essentially 2 fact tables
A fact table for my Materials which contains Material, Volume in Stock (VoS) and Material Price
And also a Customer fact table which contains Customer, Volume Sold and Value Sold
I need to create a pivot table displaying Material, VoS, Volume Sold and Value Sold
I left join the customer table to the material table - and then load the fields into a qvd - then load the qvd in my scrpit and drop the original material/customer table
My issue is that the VoS figure is being multiplied by the Volume Sold figure when I load the customer fact table into my script
When I exclude the customer fact table the VoS figure is correct, however when I include the customer table the VoS figure increases dramatically.
Hopefully this makes sense
Thanks
