Hiding CV Row

There is an option to mark a row as not visible here:

But I think if you do that and that row is used in another row for CV math, you will get an error.

There are a couple work arounds:

1. Put all the rows that are needed for CV math at the bottom and use Text=Transparent to make them appear blank.

2. Create an account rollup in the account hierarchy for the sub-total for which want in your cube view and use that parent account instead

Here are some other options in these posts:

Hiding CV Row - OneStream Community (onestreamsoftware.com)

https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/I-am-building-a-cube-view-I-have-a-row-that-is-a-calculated-row/ta-p/1204