Sort and sum

[Serene]

Hi everyone,


I have imported some data from Access.

I have some columns that I wish to sort. For eg,

(1) Location

(2) Job Grade (Staff, Supervisor, Manager, Senior Manager, etc)

(3) Dept


I would like to sort in the following order

- By Location

- By Dept

- By Job Grade

The location, dept and job grade are all at different columns.


For eg, under the Dept, I should see the staff under this dept with the highest ranking staff (Manager) on top


The sum of the salaries to be at the dept level, then the location level.


How do I do both the sorting and the sum automatically. Any advice is greatly appreciated.


Thank you

Serene

 

[kaushik03]

Serene,


Can you upload your file (with dummy data) in order to get a speedy solution of your problem?


Kaushik

 

[Hui]

You can also do the Sorting First

then

SubTotal from the Data, SubTotal menu


If you want the manager on Top you may want to add another field where the values are based on position eg: Staff=1, Supervisor=2, Manager=3, Senior Manager=4 etc

Then sort on that field instead of Position

 

[Serene]

Hi Kaushik,Hui,

Thanks for your helpful and speedy response.

I have managed to incorporate your suggestions.

For the sorting, I realised I could create a custom sort (at the child level) so that I can determine the order, for example, Manager, Supervisor, staff


Thanks again, you all have been fantastic!

Serene

 

[kaushik03]

Glad to hear that your problem is solved..