Unable to aggregate numeric or currency fields

[Madraykin]

Hi All,

I have a large spreadsheet and am just learning Power View and PowerPivot - I have a load of numeric and currency fields in my spreadsheet, but only one (the unique identifier) is coming up with the sigma sign next to it meaning that I can aggregate the data.

I want to be able to average some of the other currency fields for example but can't work out why Power View isn't seeing them as aggregateable (if that is a word )

Any help greatly appreciated

Madraykin

 

[akice]

You first need to check the column data types in power pivot. Make sure are Decimal Type or Whole number.