sorting data in groups at pivot table

Hi,

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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