+ Reply to Thread
Results 1 to 2 of 2

Pivot Table: show column 1 count data as % of last column count data

  1. #1
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    Pivot Table: show column 1 count data as % of last column count data

    Okay, have a pivot table for assignments

    doing grad research, sent out preliminary questionnaires.

    for all rows in source data, the last column is never blank so I've have it in the pivot table as count data as a total of questionnaires received from various sources/experiment groups

    then I have the questions as data. ie "Do you like pepsi?" with that expressed as count data (number of ppl who ticked either yes or no)

    What I want to do is express column 1 (question) as a percentage of the count data in the last column (this would be percentage of ppl who did not leave question blank, or technically
    column one = # of non-blank responses for question/# of questionnaries received
    any suggestions?

  2. #2
    Forum Contributor
    Join Date
    10-17-2008
    Location
    Vancouver
    MS-Off Ver
    2002 and XP
    Posts
    117

    Re: Pivot Table: show column 1 count data as % of last column count data

    Okay, solved this via VBA calculated helper column,

    For the source data, I had a
    [CODE]for each cell in myrange [CODE] macro that computed the percentage for each item,
    then I added an average data field in the pivot table for that column

+ Reply to Thread

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