I want to apply aggregation on my view so that only first row of each group should be displayed after group by aggregation.
I have a view with two fields Subject and Due_Date and sorted values like,
Subject Due_Date
A 2016-03-24
A 2014-06-28
A 2012-10-15
B 2013-11-21
B 2011-10-18
B 2010-03-04
C 2013-07-13
C 2012-12-09
After group by aggregation I want it to have like this,
Subject Due_Date
A 2016-03-24
B 2013-11-21
C 2013-07-13
It should only have the first row of each group.
I have tried Views aggregator plus, but it is just hiding the values and not eliminating them. With that I couldn't get my filters working the way I need.
Is there any solution for this to work?