How to use column(1) value in expression

[#1]

Dear Experts ,

In my report i want to count no of shipment and display origin in expression . Please look in to my qvw and attached image .

I want to count no of shipment for the last 6 months before the last job date , i,e my last job date is 21-Mar-2014 .

totally there is 5 shipments from last job  to last job - 180   (41539 to 41719) . also i want to show my origin value for the max job id 41719 .

Please help me .

[swuehl]

What is determining the priority, GP_LOCAL?

Try for destination:

if(column(1),

Concat(

aggr(

if( max(total<Customer> if(Len(if(JOB_DATE>=vToDate-vRange and JOB_DATE<=vToDate,JOB_REF))=0 and Len(if(JOB_DATE<=vToDate-vRange,JOB_REF))>0 and Len(if(JOB_DATE>=vToDate,JOB_REF))=0,JOB_DATE)) = JOB_DATE

  , Destination), Customer, JOB_DATE, Destination),', ' ,-GP_LOCAL)

  ,0)