For the columns that you want to filter, use the

DECODE

syntax, and then just leave it out for the grand total one..