I can't change count to average in pivot table data

G

Guest

I have a calculated field feeding data in an access pivot table, I need to
have an average but it keeps showing only a count and the options to sum,
count, STD, etc are greyed out. I cant change the data format either, I need
currency but it keeps showing general even after I change the field settings.
Why cant it be as simple as excel pivots!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table calculated field Count(field) / sum(field) 0
pivot table questions- Access 2003 2
Pivot Table Field based on two data area fields 3
Multi Axis Pivot Chart 12
Multiple formulas in Pivot Table 3

Top