Powerpivot measures not reflected in pivot table

[Rhino_Dance]

I have data in my Powerpivot window which was generated by a sql query. This data includes a field named 'Cost' and every row in the Powerpivot window has a 'Cost' value greater than zero. The problem is, when I display this data in the pivot table all entries for Cost display as $0. At first I thought that maybe Cost was set to a bogus data type (such as 'text) but it is set to 'Decimal Number' so that's not the problem.


What is happening? And how do I fix it so that my pivot table reflects the 'Cost' instead of showing zero?


Thanks.

 

[Matt Allington]

What is the measure formula you are using?