[FONT="]To simplify, I have a data table with a code field and then many other numeric field to use for various calculations. It is related to a lookup table that has the code, a code desc, and a code weight value. In my powerpivot table I've pulled in the Code and Code Desc from the lookup table in the Rows section and some numeric data from the data table that sums and averages nicely. I only get rows of the code and desc where there are records in the data table. BUT when I put the Weight field from the lookup table into the Values section of the pivot table I then get a row for every value in the lookup table even if that code is not in the data table but the Value area for those Codes is null. How do I pull in the weights from the lookup table into the Values area?[/FONT]
[FONT="]
[/FONT]
[FONT="]