Filter view on each group

(0) Share

Report

Posted on by CrmUser101

180

Hello,

I have to filter below view , I have to remove latest task from each group, highlighted need to removed from system view
Task. Subtask Created Date

Task 1 Sub task 1. 1/1/2022

Task 1 Sub task 2. 2/1/2022

Task 1 Sub task 3. 3/1/2022

Task 2 sub task 1. 1/1/2022

Task 2 Sub task 2. 4/1/2022

Task 2 Sub task 3. 6/1/2022

and so on

can some help me to create this filter?

Thanks,

Categories:

Microsoft Dataverse

Tables

Entities

All responses (1)

Answers (0)

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (0)

Report

Re: Filter view on each group

Hi @Shafdev ,

Its tricky to filter in such kind of scenarios.
Although there's 1 way simple way you can achieve this by adding another field that determines if that's latest task from the given group.
You need to set this field as true and all other old tasks will have this as false.

Then use this filter to check all tasks where the field value is true to filter all latest tasks only.

Note: When you create a new Task -> Set Default value to as true determining it is latest and find other Task in same group and set the Field to false (indicating old Task)

Hope this helps