the other dimensions are the same, the only difference is the measure column "Total". I can get them either all roll up or to all be broken out into unique records, what need is the ability to condition that roll up base on the value of the "total" attribute. All contract numbers that are the same with a "total" greater than 150K roll up all others break apart into separate records.
the totals are just loaded from the data set
Can you try this.
LOad * Inline [
Load *, dimension&'|'&RowPatNO as AggDimension;
lOAD *,if(dimension=previous(dimension),peek("RowPatNO")+1,1) as "RowPatNO"
Resident tempData order By dimension, measure Desc;
Drop Table tempData;
Then Use this expression to calculate the New measure
IF(measure>=150000, measure, Aggr(Sum(measure), dimension))