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.
+46Pivot 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.