I need help in filtering an entire group of similar value rows in views.
I have two columns: Subject and Due_Date in my view.
After aggregation and sorting the values of this view are like,
Subject Due_Date
A 2016-03-24
A 2014-06-28(hidden row)
A 2012-10-15(hidden row)
B 2013-11-21
B 2011-10-18(hidden row)
B 2010-03-04(hidden row)
C 2013-07-13
C 2012-12-09(hidden row)
Applied aggregation: Group and Compress on Subject field; Display first member on Due_Date.
So only the first row of the subject is displayed and all other rows are hidden.
Today's date is 2015-09-08.
I want to filter all the rows of subject if it has Due_Date greater than today (2015-09-08).
In that case, the subject A should be entirely filtered out and would only display subjects B and C as following,
Subject Due_Date
B 2013-11-21
B 2011-10-18(hidden row)
B 2010-03-04(hidden row)
C 2013-07-13
C 2012-12-09(hidden row)
How would I achieve this?
Comments
Comment #2
siddhu151plex CreditAttribution: siddhu151plex commentedComment #3
siddhu151plex CreditAttribution: siddhu151plex commented