I have a simple table
and I would need to display the data in the following format:
I think this is to do with the Set Analysis but I do not know how to get the Opening Balance Expression correct.
Please help and thanks in advance.
Use this for opening balance in a chart like that in your post
= Above[MonthEnd Balance]
View solution in original post
You can try Above([MonthEnd Balance]) in your expression.
1. Load Data
[Data]:LOAD * INLINE [Years, Months, MonthEnd Balance2012, 1, 1002012, 2, 2002012, 3, 3002012, 4, 4002012, 5, 5002012, 6, 600];
LOAD * INLINE [
Years, Months, MonthEnd Balance
2012, 1, 100
2012, 2, 200
2012, 3, 300
2012, 4, 400
2012, 5, 500
2012, 6, 600];
2. Create Straight Table with:
a. Years and Months as Dimension
b. Two Expression
i. SUM([MonthEnd Balance])
ii. Above([MonthEnd Balance])
See the sample attached file also.