I haven't worked with cross tabs much, so I don't know of the following is possible. I want to average each column but I need to exclude certain values. For example, my columns are dates and each row is an assessment.

Situation 1: exclude the lowest 2 scores from the average. Situation 2: exclude certain assessments based on some flag.

Can this be done?

Thanks in advance.
Lauren