how do I put a value in a sql field that will not be counted in a excel pivot table?
I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables.
The field I am interested in has either a text value or a NULL: CaseID (varchar (15), null).
When I...