Quote:
Originally Posted by jdkoerner
When I converted the data to a table in the same sheet as you did, the filter on top of column AB didn't have a zero option to check or uncheck; what it had was "blank". so is there a particular type of table I should be using?
And, how did you create that nifty total row with the pull down functions? Is that also a function of the table itself?
|
That may be because you manually hid the data. If not, then you need to look at what is in that column for the NL players. If it's no longer zero as in the data you posted earlier, then you'll have to find another way to differentiate between the leagues if that's still what you need.
The total row can be added after you Format as Table. Go to Table Design on the ribbon, Table Style Options, check Totals row.