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
Alternatives for conditional expansion - are there any?
I have a reporting requirement. Projects rollup into customers in UD1. UD6 contains employees. Reporting requirement is to display both customers and projects U1#Total_Customers.DescendantsInclusi...
Two thoughts:
1. Custom member lists are defined in Finance Rule types, try putting your logic there. If you need a sample starter check our the List Ranked snippet.
2. This should be possible with regular member expansions and clever conditional formatting. It requires the use of indentation, the setup:
On your row pov:
U1#Total_Customers.ChildrenInclusive,
U6#Total_Employees.ChildrenInclusive
Header Formatting:
If ((RowE1IndentLevel = 0) AND (RowE2IndentLevel > 0)) Then
TextColor = Red
End If
That should highlight the rows you want to hide in Red. In theory, you should be able to replace the TextColor=Red with IsRowsVisible=False; but that doesn't seem to work. Feels like a bug to me.