KB45640: When using totals and sorting on a metric in a grid visualization after saving the Visual Insight dashboard the totals are mixed with the rest of the rows in MicroStrategy Web 9.3.1.

SYMPTOM:
When using totals on a grid in Visual Insight in Strategy Web 9.3.1, the totals will display at the bottom of the grid like shown below. 
 
 

Sorting on an attribute or metric will sort the rows on the grid separately from the totals, which means the totals will remain at the bottom of the grid. This is the expected behavior.
However, after saving this Visual Insight report and re-executing it, if the user were to sort the metric one more time, the totals will now be sorted within the rows of the grid, like shown below.
 

 
STEPS TO REPRODUCE:
Follow these instructions in a Strategy Tutorial Project:

• Create a Visual Insight with the attribute 'Region' and the metric 'Revenue' on a grid visualization.
• Click on Region, go to Show Totals and select Total and Average, like shown below
  

• Save the Visual Insight, close and reopen it.
• Click on 'Revenue' and Sort Ascending.
• Notice the totals are sorted within the rest of the rows.

 
CAUSE:
This is a known issue in Visual Insight dashboards in Strategy Web 9.3.1. 
 
ACTION
This issue is fixed in Strategy Web 9.5.1.Please upgrade to take advantage of the fix.
 
WORKAROUND
If the sort is performed before saving the dashboard and the dashboard is then saved, the correct sorting will always be displayed during the initial run. However this will not prevent the issue from happening if the user sorts the grid again.