KB37402: Extra "Metrics" column issue with pivoted reports. Even when "Remove extra column" is checked, the word, "Metrics" persists with MicroStrategy Web 10.x

SYMPTOM:
Even when "Remove extra column" option is set to "Yes," exported results in Excel for some reports still have a word, "Metric" in the grid in Strategy Web 10.x.
 
STEPS TO REPRODUCE:
Execute the following in Strategy Tutorial:

• Create a report with Quarter attribute in the row, Year and Category attributes and Cost metric in the column of the grid. (Place Cost at the bottom among 3 objects in the column.)
   
  

• Execute the report and export to Excel with the option, "Remove extra column" to "Yes"
   
  

• Notice that the extra column has been removed and there is no word, "Metric," in the exported result.
   
  

• Go back to the report and pivot Cost metric to be in between Year and Category attribute.
   
  

• Export to Excel again with "Remove extra column" option to "Yes." Notice that the word "Metric" appears next to the columns for Cost metric while extra blank column has been removed. 
   
  

CAUSE:
This is working by design. Because the option for "Remove extra column" is removing the column, when the metric is not the one placed at the bottom, the column that would hold the header of the attribute (in this example, Category) is also removed. 
 
ACTION:
Place the metric below all attributes in the column to make sure that selecting "Remove extra column" makes sense for the grid design.