Results 1 to 5 of 5

Pivot table - icon choices

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2013
    Location
    Milwaukee, USA
    MS-Off Ver
    Excel mac 2011
    Posts
    12

    Question Pivot table - icon choices

    Hi guys,

    I am trying to make sense of a small survey I have carried out.

    We supplied some children with a sheet asking them to put their age, and to then circle up to 5 of their favorite animal icons.

    This data was entered in a spreadsheet with a column for age, and then columns for 'icon 1' 'icon 2' 'icon 3' 'icon 4' and 'icon 5', then the name of the icon entered below. (see attached picture)

    In the pivot table I want to show for instance how many 5 year olds chose the horse icon. It doesn't matter if it was choice1, or choice 5 - I just want the overall number! I can only seem to show per icon eg how many 5 years olds chose rocket for their first choice (icon 1). I just want the overall number! Please help

    Please see attached file.

    Many thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can I Get Pivot Filter Choices without VBA
    By davegugg in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 12-28-2012, 02:54 PM
  2. Conditional Formatting W/Icon Sets in Analysis Services Pivot Table
    By puffster in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2011, 03:49 PM
  3. Drop-down list choices restricting choices of other lists?
    By not_quite_excelling in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-25-2011, 06:04 AM
  4. Replies: 0
    Last Post: 06-02-2009, 10:27 AM
  5. [SOLVED] Pivot Table - Drop down choices
    By Hugues in forum Excel General
    Replies: 1
    Last Post: 06-09-2006, 08:45 PM

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