Automatically adding values in Pivot Table

[#1]

I have attached a sample app and this is probably a very simple fix, but I am new to QV and haven't been able to figure it out. Normally when I add a column to the pivot table it will automatically add the values from 2 different rows. Well for some reason it is not doing this. If I select multiple periods it is not adding the 2 rows together. For instance if I select period 4 the volume allowance column has data and if I select period 5 the data is there, but if I select both of those periods simultaneously it shows "-" (NULL). What have I done wrong.

[#2]

In your expression you must use Sum(VolumeAllowance) instead of VolumeAllowance.

Is it normal that your data are missing except for CC=1713 ?

jjj

[#3 · Accepted solution]

Thanks...I thought that. I modified the query to only show that specific CC for the sample.