This property, as the name suggests, will be applicable for your CrossTab visualization and will allow you to enable and use options like Grant Total, Subtotal, Row total, column total etc. This is avalaible from Helical Insight version 5.0 GA onwards.

Create a crosstab report  and then navigate to Properties Module.

Within Properties, choose the meatball icon again and select Crosstab.

You can now choose to enable Grand Total, or Sub Total to be calculated for your crosstab chart. Also you can decide if you want to keep them for rows or columns, place it before all other values or at the end. Let us see all these options. The UI and explanation of these are being revamped and worked on, but you can enable them to use those functionalities.

Grand Total

• To show the Grand totals, enable the first slider Show Grand Totals.
  • Under that you have option to enable the grand total at row level, or at column level. Based on your needs you can enable one or both of them. Show Row Grand Totals and Show Column Grand Totals

Once enabled and applied you’d see the effect that the grand total row and/or column gets added to your visualization

By default these are added at the end of the chart. But if needed you can get them at the beginning by selecting the Grand Total Position dropdown and choosing Top.

Sub Totals

Just like Grand Total values, you can also enable total values at each of the sections.

• To show the sub totals, enable the first slider Show Sub Totals.
  • Under that you have option to enable the grand total at row level, or at column level. Based on your needs you can enable one or both of them. Show Row Sub Totals and Show Column Sub Totals

Once enabled and applied you’d see the effect that the grand total row and/or column gets added to your visualization for each of the sections.

You can also control the position of the sub totals with Sub Total Position.

Note: Please note that the calculation will work on aggregate functions as expected like Count, Sum, Min, Max, etc. However, in case of Average it will give the average of the individual values, which might not be the accurate value. Please use it as per the limitation of the data extracted from database.