Match and Max Date

[cbaqir]

I only want to show the row with the most recent start date per DEFECT_ID... in this case 5/3/17 with a total of 77 days.

I need to adjust this dimension to show only the MAX GPQ2_START_DATE when CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0:

=date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null()) , 'MM/DD/YYYY')

Can anyone help? TIA!

[vishsaggi]

Is this sheet hidden again? 🙂

[vishsaggi]

Dont worry i got it. Will let you know.

[cbaqir]

dang it!

[vishsaggi · Accepted solution]

Try this?

= Aggr(IF(Rank(Date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null())), 0) = 1, GPQ2_START_DATE), DEFECT_ID, GPQ2_START_DATE)

Then Check Supress When Value is Null for that calculated dimension.

[cbaqir]

Thanks again!