Results 1 to 5 of 5

sorting data in groups at pivot table

Threaded View

ruleworld sorting data in groups at... 01-07-2011, 09:44 PM
jeffreybrown Re: sorting data in groups at... 01-07-2011, 10:20 PM
ruleworld Re: sorting data in groups at... 01-07-2011, 10:25 PM
jeffreybrown Re: Solved - sorting data in... 01-07-2011, 10:29 PM
ruleworld Re: Solved - sorting data in... 01-07-2011, 10:31 PM
  1. #1
    Registered User
    Join Date
    08-01-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    7

    Question 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.
    Attached Files Attached Files
    Last edited by ruleworld; 01-07-2011 at 10:31 PM.

Thread Information

Users Browsing this Thread

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

Bookmarks

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