I am building a cube view, I have a row that is a calculated row – for example in Row5 I have the formula: GetDataCell(CVR(Row4,1)).

I don’t want to see Row4 when I run the cube view so I set the Header Format to IsRowVisible = False. 
When I do this I get an error for the Row 5 – the calculated row.  It seems like for a calculated row the rows that make it up have to be visible.  I only want to show the calculated row, how do I accomplish this?

CVR GetDataCell does not work on hidden rows, it behaves as a Dynamic function. Instead of Cube View Math, try using GetDataCell Expressions pointing to intersections or use a dynamic calc to store the data.

 

Source: Office Hours 8-13-2020 Partner Enablement