J
Jonathan Oz
I have a table with values for various socioeconomic data for portions of a
metropolitan area. I would like to create a variable in a query that states
either the rank or the percentile rank of each record based upon the value of
a variable (say, median household income, or housing density). I could then
use these rankings to aggregate my data into categories. I know I can export
the data into Excel and create the values there, but that seems like a pain!
metropolitan area. I would like to create a variable in a query that states
either the rank or the percentile rank of each record based upon the value of
a variable (say, median household income, or housing density). I could then
use these rankings to aggregate my data into categories. I know I can export
the data into Excel and create the values there, but that seems like a pain!