Altium: Grouping "Not Fitted" Components In Excel BOM
I found something for you:

http://techdocs.altium.com/display/ADOH/Inclusion+of+Not+Fitted+Components+in+a+BOM

And you were right when you said in the comments that Altium is extremely versatile.