AGGR function returns value only on first row of chart

[#1]

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),

  ORDER_ID)

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:

ValueList(

'Begin',

'Buys',

'Sells',

'End'

)

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?

[bbi_mba_76 · Accepted solution]

Hi,

maybe you have to add NODISTINCT ?

[#3]

It's the simple things in life.  Thanks so much