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
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