How do I create a pivotable that 1) when it aggregate the position on fund sector instrument level it will keep the decimial (no rounding) and 2) when it aggregate on the fund sector level it will round the aggregated position to the nearest integer. 3) When it round anything above the sector level (ie fund) it will aggregate using the rounded position from the fund sector aggregation?
I can get 1 and 2 working with aggr and dimensionality but not 3
