Thanks Cyril. How do I do that? If I add a % column in the typical way it is still a % of the filtered total. How do I make it a % of the unfiltered total?
I have been working around this, but I thought I would try to see if there is a native solution I'm not aware of.
I'm using Excel 2007 and I am categorizing data as follows:
# of payments missed # of loans
Zero 14
One 3
Two...