https://community.qlik.com/t5/App-Development/Another-Trellis-Bug-Modifier-RangeSum-Doesn-t-Work/m-p/1940605#M77523 <P>Using the trellis viz the 'Modifier' doesn't work and also if converting to writing the formula manually it also doesn't work correctly. The dimension I am using to group the line graphs is 'STORE_NAME' and it's like the object doesn't pick up the dimension to group by in either scenario correctly. Anyone else encounter this or have any ideas?</P> <P>&nbsp;</P> <P><BR />=</P> <P>AGGR(RangeSum(Above( (　(SUM({&lt;</P> <P>TRANSACTION_DATE = {"&lt;=$(=today() )"}<BR />&gt;}</P> <P>IF((TRANSACTION_DATE &gt;= [CUSTOMER TRUE SOCIETY ACTIVE DATE] ),</P> <P>POS_TRANSACTION_ITEM_ADJUSTED_PRICE_USD)))　) , 0, RowNo())),STORE_NAME,MONTH_YEAR)</P> <P>&nbsp;</P> Tue, 07 Jun 2022 19:09:47 GMT jean1 2022-06-07T19:09:47Z https://community.qlik.com/t5/App-Development/Another-Trellis-Bug-Modifier-RangeSum-Doesn-t-Work/m-p/1940605#M77523 <P>Using the trellis viz the 'Modifier' doesn't work and also if converting to writing the formula manually it also doesn't work correctly. The dimension I am using to group the line graphs is 'STORE_NAME' and it's like the object doesn't pick up the dimension to group by in either scenario correctly. Anyone else encounter this or have any ideas?</P> <P>&nbsp;</P> <P><BR />=</P> <P>AGGR(RangeSum(Above( (　(SUM({&lt;</P> <P>TRANSACTION_DATE = {"&lt;=$(=today() )"}<BR />&gt;}</P> <P>IF((TRANSACTION_DATE &gt;= [CUSTOMER TRUE SOCIETY ACTIVE DATE] ),</P> <P>POS_TRANSACTION_ITEM_ADJUSTED_PRICE_USD)))　) , 0, RowNo())),STORE_NAME,MONTH_YEAR)</P> <P>&nbsp;</P> Tue, 07 Jun 2022 19:09:47 GMT https://community.qlik.com/t5/App-Development/Another-Trellis-Bug-Modifier-RangeSum-Doesn-t-Work/m-p/1940605#M77523 jean1 2022-06-07T19:09:47Z