Extracting data
My OLAP tools are greyed out so I can't do drill in or out.
I have a list of over 30,000 companies with property. I want to extract data based on the number of properties each company has. Seems like that would be easy but the data is numbered with "1's" because of the way the data is collected so the only way I know to sort the data and sum this amount of data is in a pivot table.
Any thoughts on that?
Thanks,
Jake
|