View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
macgolfers macgolfers is offline
external usenet poster
 
Posts: 1
Default Excel 2007 pivot table label filter

I have a dataset that originated as a SQL query. It is now an Excel
table. I am attempting to create a pivot table from it, but I cannot
get the pivot table columns to filter by labels (or by values). The
Table itself will filter fine. I've tried recreating the data, setting
it as a table and as a range.

I have another spreadsheet that uses essentially the same data, but I
I created pivot tables there for different analysis, and they work
fine.

What am I missing?
Doug