Anonymous
9 years agoNot applicable
Status:
New
cannot add a field to values section on a pivot table in Excel
I am trying to create a pivot table from an Access database connected to PowerBI. Sadly I can't add any field to the values area as I keep getting the error "The field you're moving cannot be placed ...
mickjaeger
Helper I
3 years agoCreating measures is not a challenge but what's the rationale for this? It's extremely inefficient if I have to create a measure for every field I want to use as a value in my pivot table. The fields already exist in the database and they are already assigned as SUM fields. This is completely backwards and makes the Analyze in Excel feature useless in many cases. v-haibl-msft can you please explain the technical reason for this?
Thanks,
Mick