|
|
#10
08-01-2016, 05:13 AM
|
|||
|
|||
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 
|
| Tags |
| extracting data, pivot table, show details |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to vba pivot table to deselect items but sometimes one item may not be there
|
mbesspiata3 | Excel Programming | 1 | 04-22-2016 07:32 AM |
| Include and Exclude items through vba in pivot table | mbesspiata | Excel Programming | 0 | 02-22-2016 12:30 PM |
| Selecting/deselecting items in pivot table | mbesspiata | Excel | 0 | 07-22-2014 08:15 AM |
| VBA Pivot Table CubeField Enable multiple items | Wries | Excel Programming | 0 | 03-13-2014 09:56 AM |
|
Show Items with no data
|
DeborahBartlett | Excel | 1 | 01-24-2012 01:10 AM |
Windows 10 
Office 2016
Threaded Mode