Forum Discussion

JSR's avatar
JSR
Icon for Helper II rankHelper II
6 years ago
Solved

Get data from Filtered rows

Hi, A bit lost on how best get data from specific rows so looking for any advice, thanks.   Having a table like below.   I would like to get specific filtered rows and display its info int...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi JSR ,

     

    For TITLE column, set summarisation to FIRST as highlighted below:

     

    For END DATE, set summarisation to LATEST as shiwn below:

     

    This will give you your desired result as follows:

     

    Thanks,

    Pragati

     

JSR's avatar
JSR
Icon for Helper II rankHelper II
6 years ago

Thanks Pragati11 for your super detailed answer.

But I need to do the filtering automatic, and only display the latest based on Category and dates.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi JSR ,

 

For TITLE column, set summarisation to FIRST as highlighted below:

 

For END DATE, set summarisation to LATEST as shiwn below:

 

This will give you your desired result as follows:

 

Thanks,

Pragati