Pivot Table and Pivot Chart

[mkknerr]

I have a pivot table that has calculated fields (by Row and or Column) and every time I try to view as a pivot chart it reverts back to the count not the calculated field. Can this be done and if so how. Thanks for your help. (this is in access 2003)

Thanks

MKK

[MMcCarthy]

I have a pivot table that has calculated fields (by Row and or Column) and every time I try to view as a pivot chart it reverts back to the count not the calculated field. Can this be done and if so how. Thanks for your help. (this is in access 2003)

Thanks

MKK

Post the full sql of the query you are using.