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
