Text box expression

[yogitamehta10]

Hi All,

i need to show Latest Month and cycle field in text box . my month field is like C10 2017, C92017 ,C82017. i can not do max as we i have all the 12  cycle in data all the time.
but i have a column in data that tell  this is latest cycle.)

Month field  column
c10 2017      Latest cycle
c10 2017      Latest cycle
.

.
.
c09 2017        Last cycle

i want to show Last cycle Month field in text box.

TIA!

[woshua5550]

Try this ?

Only({<column = {'Last cycle'}>}[Month field])