Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to get colum...
 
Notifications
Clear all

I need to get column-wise total in the table that I need to pivot. How do I do this?

1 Posts
1 Users
0 Likes
200 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: On the top right corner of the page, click on visualization under properties. (Refer to the image below).

1672835316-tableproperties.png

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).   

1672835342-tablelabel.png
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). 
1672835367-tablelabel1.png

   
Quote
Share: