Date Value in text box must ignore selection

[Anonymous]

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 .

[swuehl · Accepted solution]

Maybe like

=Max({<[Process 2]= {'C'}, Date= >}  Date)

resp.

=Max({<[Process 2]= {'N'}, Date= >}  Date)

[sunny_talwar]

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

[Anonymous]

Hi selvapraveen,

Try this

=Max(TOTAL {1<[Process 2]= {'C'}>}  Date)

=Max(TOTAL {1<[Process 2]= {'N'}>}  Date)

Regards!

[Anonymous]

Actually that works for me because i need the latest date with Process 2 as C

[sunny_talwar]

Awesome!! I am glad Stefan's solution worked out for you