precision in pivot table

R

RB

I have a field in my query that is set as decimal precision 19 scale 5, I
have values from 2.0 to .0008. When I pull this into a pivot form, the field
shows as a value of 0, the decimal precision is lost. How can I change this?
 
Top