EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB484420: "Show Totals” option does not work in a dossier with dataset from an imported Excel file in MicroStrategy Web 2019, 2020 and 2021


Mengran (Molly) Wang

Senior Cloud Support Engineer III • MicroStrategy


This article explains why the Show Totals option may not be working in a dossier with dataset imported from Excel. This article also provides a possible solution to avoid this behavior.

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Description 


If your dossier uses dataset imported from Excel, the Show Totals option may not work. 

ka0PW0000001Jd5YAE_0EM2R000001IDbj.jpeg

 

Why is this happening?

It is possible that metrics are defined as "Text" during data import.

Solution  


Change the metric data type to a numeric format like Big Decimal.

ka0PW0000001Jd5YAE_0EM2R000001IDc3.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

July 22, 2020

Last Updated:

March 21, 2024