Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table
Table A
Date Process1 Process2 Process3
01/01/2016 C X C
02/01/2016 C X C
03/01/2016 C C C
04/01/2016 N X N
05/01/2016 N X N
06/01/2016 N N N
Now I need to display the date in which the Process2 has value C
And the date in which the process2 has value N . These date values must not change with date selection in the list box .
Can anyone help on this .
Maybe like
=Max({<[Process 2]= {'C'}, Date= >} Date)
resp.
=Max({<[Process 2]= {'N'}, Date= >} Date)
Maybe like
=Max({<[Process 2]= {'C'}, Date= >} Date)
resp.
=Max({<[Process 2]= {'N'}, Date= >} Date)
What happens with there are multiple dates where Process2 has C in them. Similarliy what happens when you have multiple N? It would be great if you can provide some more details if what Stefan has provided doesn't work for you
Hi selvapraveen,
Try this
=Max(TOTAL {1<[Process 2]= {'C'}>} Date)
=Max(TOTAL {1<[Process 2]= {'N'}>} Date)
Regards!
Actually that works for me because i need the latest date with Process 2 as C
Awesome!! I am glad Stefan's solution worked out for you