Unable to aggregate numeric or currency fields

Madraykin

Board Regular
Joined
Jan 4, 2012
Messages
56
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

Board Regular
Joined
Apr 18, 2016
Messages
180
You first need to check the column data types in power pivot. Make sure are Decimal Type or Whole number.
 

Forum statistics

Threads
1,077,850
Messages
5,336,740
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top