AGGR function returns value only on first row of chart
I have a chart with a calculated dimension and each expression uses a pick(match()) function to use a different expression for each dimension. I have run into a problem with a new function which is below. It will only return a value in the chart at the first row in the chart. So if i put the function in the second row pick(match()) slot, it will return null because it is not the first row in the chart.
aggr( if(round(($(vTxnBucketAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))/($(vTxnBucketExclusionAgg('Buys',[Lower Of SP-Moody],BASE_MKT_VALUE)))) = ORDER_ID, sp_rc_dual),
We can simplify the above and just say aggr(if( 3 = order_id, sp_rc_dual), order_id)
The calculated dimension on this chart is a value list:
Is anyone aware of a reason or way to work around this restriction to get these values to display at all rows so they will pick up in the pick(match()) expressions?