wailoon.ho (10/22/2012)

---

Hi
My application need at least 2 approval for an request.

I need to generate a report to count which combinations are the most.

example

ApplicationID DateTime ApprovalUserID
1 10/10/2012 1
1 10/10/2012 2
1 10/10/2012 3
2 11/10/2012 1
2 11/10/2012 3
3 12/10/2012 2
3 12/10/2012 3
4 13/10/2012 1
4 13/10/2012 2
5 14/10/2012 1
5 14/10/2012 3
6 15/10/2012 1
6 15/10/2012 3
7 16/10/2012 1
7 16/10/2012 2

My report should show
Approval1 Approval2 Approval3 Count
1 2 3 1
1 2 2
1 3 3
2 3 1

I manage to the the result like above but without the COUNT.
I really no idea how to make script work. Please help.