Hello. How is it possible to calculate the sum of a column on a pivot table? On a single table there is the 'Add calculation'' option....
Solved
How to calculate the sum of the column on a pivot table?
+3Best answer by CarolK
Pivot table doesn't do column sum (or at least not at this time) unless something has changed since something to this same effect was posted in the Dashboards section. I commented on a product idea in that section, because it seems like a major gap for something called a "Pivot" to not give the option for Column & Row totals.
+48Pivot table doesn't do column sum (or at least not at this time) unless something has changed since something to this same effect was posted in the Dashboards section. I commented on a product idea in that section, because it seems like a major gap for something called a "Pivot" to not give the option for Column & Row totals.
+19I just upvoted CarolKthis idea: https://community.qualtrics.com/XMcommunity/discussion/6447/improved-pivot-table-functionality-sort-by-row-headers-and-sub-headers-and-nested-totals
This is definitely a huge gap.
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.