I have two problems I can't seem to fix.
1: I need to get a sum per a max date but no matter which formula I use I don't get correct result (Pivot: Paid)
2: I need to have a rangesum (above and below) in order to find primo and ultimo balance for a second dimension in a pivot with two dimensions and the rangesum should be for the first dimension (Pivot: Primo balance).
Please see attached where I have illustrated what I want and the formulas I have used.
Any help would be much appreciated.
