View Single Post
 
Old 08-01-2016, 05:13 AM
jhato160 jhato160 is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2016
Posts: 13
jhato160 is on a distinguished road
Default 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
Reply With Quote