Pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day..

I have monthly phone records with the folowing headers:-
number dialed; duartion of call; date ; cost ; and a couple more headers.

Is ther a manner that I could sort the list to indicate the phone number of
the most frequently dailed numbers,followed by the next, etc... then the
total number of times a number was dialed and the cost$ of all calls to that
number?

Please assist.
Thanx.....
!ngeniuos
(99% Perspiration)
 
In the pivot table, put Number dialed in the Row area, and another copy
of Number dialed in the Data area, as Count of Number Dialed.
In the data area, also add Cost, as Sum of Cost.
Select a cell in the Count of Number Dialed column, and on the toolbar,
click the Z-A button.
 
Back
Top