Sorry for the weird title, but I couldn't figure out how else to reword it.
I have the following example data from a phone system:
CalledParty CallingParty Minutes
10300..............5105551212......... 5
5105555555 ... 10300..................8
10300................44444................. 9
10301............... 5105558888........1
etc......
I want to search based on a wildcard (eg. everything starting with 10*) by either CalledParty or CallingParty field. But I want to end up with the result:
Extension MinutesTotal
10300............ 22
10301..............1
Basically combining the counts from the Calling and Called as Extension.
However, I have only been able to put something together that produces this:
10300............... 5105551212....14
5105555555......10300................8
10301.................5105558888.....1
Sorry for the formatting, hopefully this makes some sense. Is there any way to combine these in this way? Thanks in advance.
-shane
... View more