How to reference a column that is hidden
From SmartWiki
Q: How do I create a column in a report that is referencing a hidden column?
A: To do this, you need to edit the report template instead of unchecking the column's visibility in the report builder.