Hi
We are developing a water fall report which has 1 dimension and 1 expression. We have a hierarchial model where in users can select nodes at any level. The start bar should have prior year YTD value of the node, End bar should have current year vale of the node. The delta between these two values should be displayed at the child level of the nodes. We are able to display the bars correctly. But not sure what to set in the bar offset, since 1 expression is so complex and calculates the values for prior YTD , current year YTD at parent leve as well as calculates the delta at child level. The expression is dynamic which may change whenever the user select a different node. Can someone give a idea to implement a solution for this.
