Pivot Table Query

[uk]

I need to use a pivot table to group the result.

I have a raw data Table which has Employee ID, CITY, Salary, Age

Raw Data

ID City Salary Age
1 LONDON 17500 23
2 BHAM 16000 20
3 MANCH 14000 19
4 LONDON 25000 60
5 LONDON 13000 17
6 BHAM 11000 18
7 MANCH 13500 28
8 LEEDS 18200 25
9 GLASGOW 19000 21
10 LONDON 20000 24

From this I want to create a pivot table,,,,

I want to be able to group by a salary range I specify in 3 different cells
>20000
>15000
>10000

The pivot tables should count the number of people in each salary range.

 

[Yogi Anand]

I need to use a pivot table to group the result.

I have a raw data Table which has Employee ID, CITY, Salary, Age

Raw Data

ID City Salary Age
1 LONDON 17500 23
2 BHAM 16000 20
3 MANCH 14000 19
4 LONDON 25000 60
5 LONDON 13000 17
6 BHAM 11000 18
7 MANCH 13500 28
8 LEEDS 18200 25
9 GLASGOW 19000 21
10 LONDON 20000 24

From this I want to create a pivot table,,,,

I want to be able to group by a salary range I specify in 3 different cells
>20000
>15000
>10000

The pivot tables should count the number of people in each salary range.

Hi uk:

Please look at the following illustration ...

Book1
	A	B	C	D	E	F	G	H
1	ID	City	Salary	Age
2	1	LONDON	17500	23
3	2	BHAM	16000	20		CountofSalary
4	3	MANCH	14000	19		Salary	Total
5	4	LONDON	25000	60		>10000	4
6	5	LONDON	13000	17		>15000	4
7	6	BHAM	11000	18		>20000	2
8	7	MANCH	13500	28		GrandTotal	10
9	8	LEEDS	18200	25
10	9	GLASGOW	19000	21
11	10	LONDON	20000	24
Sheet4

I first created a Pivot Table with Salary as the row field and Count Of Salary as Data.

Then I Grouped the salaries, between 0 and 25000 with a step of 5000

Then I custom formated the labels for the Salary groups to be shown as ...
>10000
>15000
>20000

I hope this helps. If I have misunderstood your question -- my apologies!

 

[uk]

Yogi

The results table you made is kinda what I am after but I am not to keen on manualy grouping a table with 1000's of rows unless there is a quick wasy to do it.

Plus I have to apply the same results table to a number of spreadhseets in which the salary is not always in the same column!

 

[Yogi Anand]

Hi uk:

In the Pivot Table example I posted, I only used three numbers to create three groups even though there may be a large number of salary entries in the table. Any way, Good Luck to you on your project!