Hi,

I'm wondering if anyone out there can help me with the following task using Calc's Data Pilot (pivot table) tool.

I want to examine cell phone usage by creating a table with two data columns and several rows. Given a cell-phone bill, each row will contain the calling or called telephone number. One column will contain the total minutes spent talking to the telephone number, and the second column will contain the total charges associated with the number. The rows will be sorted in decreasing order of usage (minutes) or charges.

I can make a table with this information, but I can't get the total minutes and charges to appear alongside each other as columns. Instead, the best I can do is to get them to appear as separate rows under each telephone number. Neither can I figure out how to sort the rows based on the data in the body of the pivot table.

Thanks.

   Marsh Feldman

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to