Problem with aggregation

[#1]

Hi, I have a source table as presented below :

Portfolio	Node	Task	Date
Commercial	Project 1	A	12-11-12
Commercial	Project 1	B	10-05-13
Commercial	Project 2	A	15-12-12
Financial	Project 3	A	23-04-11
Financial	Project 4	A	22-01-10
Financial	Project 4	B	11-08-14

now i want to create this tabke :

Portfolio	Node	Date
Commercial	Project 1	12-11-12
Commercial	Project 2	15-12-12
Financial	Project 3	23-04-11
Financial	Project 4	22-01-10

As you can see I want to assign just one date to each Node - date from Task 'A'. I don't have any idea how to solve that. I can't just use if(Task='A', Date) and hide null values because i have to do similar thing in another column. Any idea ?

[hic · Accepted solution]

If you do this as a Pivot Table, you can use Portfolio and Node as dimensions, and

     Date(Min( {$<Task={'A'}>} Date))

as expression.

HIC

[pradnyat]

Hi,

Please find the attached file for the issue.

Hope this will help you...!