I need to get column-wise total in the table that I need to pivot. How do I do this? - Table https://forums.datanyx.com/community/table/i-need-to-get-column-wise-total-in-the-table-that-i-need-to-pivot-how-do-i-do-this/ Datanyx Support Forum en-US Wed, 15 Jul 2026 19:29:42 +0000 wpForo 60 I need to get column-wise total in the table that I need to pivot. How do I do this? https://forums.datanyx.com/community/table/i-need-to-get-column-wise-total-in-the-table-that-i-need-to-pivot-how-do-i-do-this/#post-424 Wed, 04 Jan 2023 12:26:07 +0000 Step 1: On the top right corner of the page, click on visualization under properties. (Refer to the image below).

Step 2: Now click on the properties icon under visualization. 

Step 3: Drag and drop the required columns in dimension and measure.  

Step 4: Click on pivot data and enable the pivot data toggle. Select the measure for pivot and chooses the dimension to be pivoted from the dropdown.  

Step 5: Under columns, click on the dimension which is at the beginning. In the image below it is “State”. Under Label, enter ‘Grand total’. (Refer to the image below).   

Step 6: Now, under columns, click on the column that is under measure. Click on the aggregate drop down and choose from the options available. The sum option will give you the column-wises total. (Refer to the image below). 
]]> Table Nikhila https://forums.datanyx.com/community/table/i-need-to-get-column-wise-total-in-the-table-that-i-need-to-pivot-how-do-i-do-this/#post-424