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 ...
in my case I have all my fields as numeric so why I still need to declare as measures. I may want to use same numeric field as average or sum or count or with statistical function. so why is it has to be decaled as measure.
thanks