Set analysis

[#1]

Hi Community,

I have below sample data -:

Account no.      Account opening date           Salary in account                          Date

1                         1/2/2015                               10                                        1/1/2015

2                          2/2/2015                              20                                       1/12015

3                          3/4/2014                              30                                        2/3/2014

4                         4/5/2014                               40                                       3/4/2014

5                         6/6/2014                               60                                       5/4/2014

i want those account no thier account opening date before june but ther salary on date 1/1/2015.

Thanks in advance.

Ishwar

[giakoum]

Dimension : Account no.

Expression :

sum({<[Account opening date]={"<1/6/2014"}, [Date]={"1/1/2015"}>} [Salary in account])

[#3]

Hi ioannis,

Thanks for your quik reply,

now i have resolve this problem.