Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1170
Filter by groupedByRows
posted

I have a table that shows the Person's ID, Name, Exam date and marks scored by him. The marks can be positive or negative based on the response provided. The data in the grid is like this:

ID   |   Date   |  Name   |  Marks  | 

-------------------------------------------------

1      3/20/14     Alex          10

1      3/22/14     Alex         -10

2      4/25/14     James         5

2      4/25/14     James        10

3      4/25/14     Peter          12

3      4/25/14     Peter         -12

If I apply the grouping By Name, Data would look like this:

-----------------------------------

1  Multiple        Alex            0

-----------------------------------

1      3/20/14     Alex          10

1      3/22/14     Alex         -10

-----------------------------------

2     4/25/14        James         15

-----------------------------------

2      4/25/14     James         5

2      4/25/14     James        10

-----------------------------------

3  4/25/14        Peter            0

-----------------------------------

3      4/25/14     Peter          12

3      4/25/14     Peter         -12

I was just wondering if there is a way that I can apply the filtering by the Group by Rows. I mean to say is if there is a way to filter the above grouped data by 0 marks and get the records of Alex and peter only (ignoring James as James does not have 0 marks).