Question: Is it possible to be able to reference rows that are not visible in Cube View calculations?

• There is an enhancement pending for this functionality. Contact Support to be added to this request.
• From 6.0.0, Complex Cube View Column Math calculations can now be derived using hidden columns. The IsColumnVisible, Column Header Formatting property now contains a new setting, CVMathOnly, which allows the column(s) to be hidden from view, yet still function within a GetDataCell Cube View Column calculation.

 

Source:  Office Hours 2021-02-04 - Partner Enablement