How to reference a column that is hidden

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.

Reports template hiding columns.JPG