Question: How can I perform Cube View calculations against hidden columns?
Answer
•When this question was posed, there were some workarounds involving the use of row/column overrides.
•However, with the release of 6.0.0 (March 2020), you can now create calculations against hidden rows/columns
Source: Office Hours 2019-07-11