Can you explain a bit more about how the % is calculated? e.g. 40% of snapchat.
Thanks for getting in touch. I hope I can answer your question here:
- The survey data set has 20 rows, besides the headers
- Each row represents a respondent
- There is one column header called "Use SnapChat"
- Below that header, 8 out of 20 cells (40%) are filled with the word "SnapChat," as 8 people, from the survey sample, responded that they use Snapchat
- There are people who use SnapChat, Facebook and Instagram
- Other people use only two of the 3 social media services
- Others use just one
- And some, none
- So there is one column to count the respondents who use Facebook, another column for those who use Instagram, and one last column for those who use Snapchat
- The dataset should look like the one shown in my original question
- In a few words, the calculation is the number of filled cells divided by the total number of rows (either filled or empty - each row representing one survey respondent)
I hope this can help.
Thanks for your response, it is helpful.
Please find my solution attached and the explain below for your reference.
I just use the 4 data rows you attached as example.
Hope this helps
Book1_v10.2.twbx 14.6 KB
Thanks ZZ. I have a question. What is AGG(Calcul...? Where can I get it? I was able to create the Pivot Table and to get the three items together as a table but with no numbers.
That's the Calculation1 as I showed in my previous reply, you need create this and drag it to Text to show the figures.