Vitara grid chart by default shows ‘Grand Total’ row at the bottom of the visualization. The default function applied is ‘Sum’. However, we can modify the default aggregation function to other functions in the list.
Therefore, the term ‘Grand Total’ is just for naming purposes and does not mean it will show only totals. The actual value of the Grand total will be calculated by using the function applied in ‘Value Aggregation’. For example, if we apply ‘Value Aggregation’ function - Max, the grand total will also show the max value among the values. Show/Hide Grand total: If we don’t want to show ‘Grand Total’ row, then we can hide the ‘Grand Total’ row. Click on the ‘Edit’ button select the ‘Grand Totals’ tab and expand the dropdown box select ‘Hide’.