Using Total DistinctCount in Pivot Table

P

Petronella

New Member
Joined
Jan 10, 2012
Messages
27
Office Version
  1. 2016
Platform
  1. Windows
I have a multiple choice questionnaire question, so each respondent (ID) can choose more than one of the choices.

For each choice I want to chart the percentage of the total number of respondents to the question that made that choice.

Let's say there are 384 respondents and 20 of them choose the first choice. To make my chart I need the number of respondents making that choice (20) and the total number of unique respondents not just the unique respondents for that question. Whilst I can see that number (in cell C11) I am unable to replicate it down the rest of column C.

I think I need a new measure but I can't work out what it should be.

Can anyone help please?


Pivot.JPG
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Bumping in the hope of help with this measure. Happy to provide more information if needed.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Result based on multiple choices.
Replies
9
Views
496
Bob119
B
D
  • Question
Showing values in a pivot table as a percentage of value in another pivot table
Replies
0
Views
843
dropjinx
D
R
  • Question
Formatting data series for chart created via Slicer and Pivot Table
Replies
6
Views
299
awoohaw
awoohaw
A
  • Question
Graphs-formula to use
Replies
7
Views
267
AnaFab
A
T
  • Question
Slicer disconnects from pivottable when programatically filtering items in pivot fields
Replies
2
Views
729
Telefonstolpe
T

Forum statistics

Threads
1,214,985
Messages
6,122,607
Members
449,090
Latest member
vivek chauhan

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top