Are you actually filtering anything out or simply placing the fields on the shelf, leaving all the members of the fields checked and then adding to context? Would you be able to provide a packaged workbook (twbx file) or screen shots? Thanks!
Yes I am filtering out one classification of inventory item
which has about 30 part numbers in its record set and yet in the show filter
window for part number it still shows all 29000 plus part numbers.
Since it is a single table I could make an extract workbook
and send that. I started to try using context on a complex sheet and could not
get it and thought it was a function of the complexity of the sheet. I dumbed
the sheet way down to one table and three fields on the row and two filters one
that was set as a context filter.
I thought it was a problem with creating the temp table on
the server but that should show me some kind of error right?
As of now I can see no difference in the behavior of the sheet
whether or not the context option is on.
Should I send a workbook with data extract?
I just saw anothe rpost about relevent values on filters. I went back and changed my filters to show only relevent values and that took the filter down to what I would have expected by setting the context.
So I got what I needed for now but I still do not understand how if setting a context limts the record set that the filters can still show all the values that were present BEFORE the context was set.
Does not seem to be the expected behavior