#N/A in PivotTable Ranking

Folks,
I'm getting a #N/A! error when trying to ranking data (largest to smallest) in my pivot table:
Rank problem PivotTableI've no clue why?
Frank FreeseAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Haris DjulicConnect With a Mentor Commented:
You need to choose Market as base field... Since any other field which is not listed in rows will produce the N/A error since it cant use it..
Capture.PNG
0
 
Jeff LewandowskiCommented:
#N/A       -       Occurs if the supplied number is not present in the supplied array of values.

(Note that the function does not recognise text representations of numbers as numeric values, so you will also get the #N/A error if the values in the supplied 'ref' array are text values)

http://www.excelfunctions.net/Excel-Rank-Function.html
0
 
Frank FreeseAuthor Commented:
I have attached the data I am using as a table.  I cannot find anything wrong with the data (I tried).
Try creating a pivot table with the row being Market and the Values being Revenue. Accept the default Values of Sum. Go back to the pivot table and change the values for Revenue from sum to Show Values As Ranked Largest to Smallest. With my data I cannot rank revenue, quantity, or any thing.
MoreData.xlsx
0
 
Frank FreeseAuthor Commented:
I JUST figured that out - but thanks for the affirmation
0
 
Frank FreeseAuthor Commented:
thank you kindly
0
All Courses

From novice to tech pro — start learning today.