The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MarioGV's avatar
MarioGV
New Contributor III
3 years ago

Cube view using complex function Account

Hello; Im crating a cube view with 2 rows (maybe more) that one of them is a result of a complex function: "A#INCOME_STATEMENT.Base.Where(Text1 Startswith On-Campus)" and shows several rows qualifi...
dashboards
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
3 years ago

Remember you can always hide a row or column, setting the IsRowVisible (or IsColumnVisible) property of Header Formatting. If you set it to CVMathOnly, the row/column will be available for math operations, but won't be visible.

So for example, you could have a row defined with your complex filter, but not displayed; and then you could have another row that gives you the sum of those values.