Set Analysis with a set

[Anonymous]

Customer Name	Posting Date	Clearing	Value	Flag
A	31/10/2015	2/11/2017	22	1
A	31/10/2015	1/10/2017	14	0
A	31/10/2015	28/10/2017	12	0
A	25/10/2015	14/11/2017	32	1
A	25/10/2015	2/11/2017	14	0
A	15/10/2015	12/11/2017	23	1
A	15/10/2015	5/11/2017	11	0
A	15/10/2015	2/11/2017	11	0
A	11/10/2015	14/11/2017	9	1
A	11/10/2015	12/11/2017	2	0
A	11/10/2015	11/11/2017	10	0
A	11/10/2015	2/11/2017	9	0

Hi i have data in the above format the flag field is not their and even the customer not in the same table but i want to implement the set analysis on front end for all the flag =1 fields . i.e means i want to showcase only the flag=1 fields in front-end table for posting date till date selection  . Suppose user gives a selection 31/10/2015 in posting date he should be able to see all the flag=1 records.(Note :- Clearing date is considering only the max date )

[shraddha_g]

According to sample data, Please provide expected output

[Anil_Babu_Samineni]

Perhaps this?

Only({<Flag = {1}>} [Customer Name])

OR, I believe you have something called expression. In that try to add Flag = {1}

[neha_shirsath]

What you want to show exactly,Means count of customers with Flag =1 or Sum of value with Flag =1?

[Anonymous]

Customer Name	Posting Date	Clearing	Value	Flag
A	31/10/2015	2/11/2017	22	1
A	25/10/2015	14/11/2017	32	1
A	15/10/2015	12/11/2017	23	1
A	11/10/2015	14/11/2017	9	1

This will be the Output

[Anonymous]

I dnt have the Flag field as i cannot be created i want to do the following in the Front end cant go to backend creat new field .

[Anonymous]

Sum of Values

[shraddha_g]

Try

Sum({<Flag = {'1'},[Posting Date] = {"<= $(=max([Posting Date]))"},[Clearing Date] ={"=$(=max([Clearing Date]))"}>} Value)