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?
=
AGGR(RangeSum(Above( ( (SUM({<
TRANSACTION_DATE = {"<=$(=today() )"}
>}
IF((TRANSACTION_DATE >= [CUSTOMER TRUE SOCIETY ACTIVE DATE] ),
POS_TRANSACTION_ITEM_ADJUSTED_PRICE_USD))) ) , 0, RowNo())),STORE_NAME,MONTH_YEAR)
