sorting data in groups at pivot table

Hi,

I have a table of gender, frequency and income like this

Gender	Frequency	Income
Man	4	30
Man	4	58
Man	6	48
Woman	6	58
Woman	5	53
Man	3	49
Man	5	48
Man	6	52
Woman	4	47
Man	4	63

where the frequency is the number of times they go to fastfood shops per week. There are 150 data in the table. I need to summarize the data in a pivot table according to gender and income group. I thought of something like this

Income Group	Man	Woman
below 40	            3.2	3.1
40-60	            4.1	4
over 60	            3.5	3.2

I don't know much about pivot table please help.

Hi ruleworld,

You might want to take a few minutes and read the forum rules before you post again.

If you care to post in two forum's at that same time please include a link to the other post for everyone's benefit.

http://www.mrexcel.com/forum/showthr...76#post2566876

Since it appears you have said the answer in the other forum has satisfied your request, please don't forget to mark this thread as solved.

Hi, i am new here will read rules before i use it again. can you tell me how to mark it as solved? thanks

You can find it at the FAQ's.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save