Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
04/01/2023 12:26 pm
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).
