Hide source rows in Cube View math

PKiernan
New Contributor III

For columns there is formatting for CVMathOnly, but there is not for rows. What methods are used to be able to use the row as a source value, but not display? Place at bottom and format? Using a live app where the hierarchies are set.

1 ACCEPTED SOLUTION

db_pdx
Contributor III

You can use zero suppression with a sufficiently large threshold value to effectively hide the rows.  That said, you may consider putting your math into a DynamicCalc member or a basic GetDataCell formula.

View solution in original post

1 REPLY 1

db_pdx
Contributor III

You can use zero suppression with a sufficiently large threshold value to effectively hide the rows.  That said, you may consider putting your math into a DynamicCalc member or a basic GetDataCell formula.