Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm sure that this is an aggr or set analytics but I can't see it...
With the below data, I need to get latest period balance for each code and then be able to sum that.
Period, Code, Balance
1, 1, 0
2, 1, 100
3, 1, 150
4, 1, 200
5, 1, 00
6, 1, 0
7, 1, 100
8, 1, 0
9, 1, 50
10, 1, 10
11, 1, 500
12, 1, 150
1, 2, 100
2, 2, 150
3, 2, 200
4, 2, 50
5, 2, 10
6, 2, 500
7, 2, 150
8, 2, 0
9, 2, 0
10, 2, 0
11, 2, 0
12, 2, 0
Any thoughts?
And you would like to do all of this in the script or the front end of the application?
I need to drill down so this needs to be in the front end
Is this what you are looking for? In a text box object?
!
Afraid not, I need this to be in a pivot table so I can group by Quarter, Year or period - this only works for an overall sum
From the data you have shared, would you be able to draw me a picture of your expected output?
!