# how to list the employees with respect to the salary brackets???

1. ## how to list the employees with respect to the salary brackets???

i've attached a pivot table.. what i need is

1) To list the employees with respect to gender

2) To list the employees with respect to the salary brackets of 20-25,26-30,31-35,36-40. Also display it with graph...

make both on different sheets...

2. ## Re: how to list the employees with respect to the salary brackets???

what exactly u need from this, here in this attached sheet only raw data is thr.

Thanks - Naveed.

3. ## Re: how to list the employees with respect to the salary brackets???

By 'list employees' I assume you mean count? Or do you just mean sort them and divide?

4. ## Re: how to list the employees with respect to the salary brackets???

No here i question is , in which way u need output that explain me i will try to resolved thts it from my side.

5. ## Re: how to list the employees with respect to the salary brackets???

@jake.. i meant sort them and divide according to their salary in pivot table...

6. ## Re: how to list the employees with respect to the salary brackets???

sort them and divide according to their salary in pivot table...

7. ## Re: how to list the employees with respect to the salary brackets???

i knw the first part "to list the employ with respect to gender"

I'm having difficulty in second part...

8. ## Re: how to list the employees with respect to the salary brackets???

Just create a pivot table and drag the different segments into the right side.

Like this:

Is that what you were looking for?

9. ## Re: how to list the employees with respect to the salary brackets???

once have a look and let me know if its not meeting ur requirement let me know.

i will come back again here after 1 hour then i will try to resolve through formulaes.

Sorry if its not meet ur requirement.

Thanks - Naveed.

10. ## Re: how to list the employees with respect to the salary brackets???

where are the salary brackets? 20000-25999,26000-30999.etc?

12. ## Re: how to list the employees with respect to the salary brackets???

Originally Posted by jake.masters
thx for you help

I quite completed the arranging task.. still facing problem with graph.. anyways thanks for your time and effort...

13. ## Re: how to list the employees with respect to the salary brackets???

Originally Posted by Naveed Raza
once have a look and let me know if its not meeting ur requirement let me know.

i will come back again here after 1 hour then i will try to resolve through formulaes.

Sorry if its not meet ur requirement.

Thanks - Naveed.

thx for you time naveed

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1