This query is regarding sum up columns based on value on some threshold point.and like in column we have age band so if 0-90 has amount greater than threshold that should not appear in the pivot or if we can threshold on 91-180 like if 91-180>sum(50) then that reinsurer to be included.
For example pls see attached file.