SUM for the column is not calculated

[KK22]

Hi, I have a table Persentages where I manually changed column setting for March because when I refreshed data  Mar didn't come with the Σ sign.

However a Total for March is not showing on the report.

Please help me with explaining what I have done wrong.

Thank you.

[jgeddes · Accepted solution]

One cause of this could be that there are none integer values in your March data. 
You can check this by clicking on the Transform data button and checking the data type of the March column in your table. 
If it is set as text, try and set it to decimal number. If that results in an error you will need to correct the cause of the error. 

[v-heq-msft · Accepted solution]

Hi  @KK22 ,
I’d like to acknowledge the valuable input provided by the @jgeddes   . His initial idea were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue. 
First for your comment about the sigma symbol not appearing after a data refresh. The first reason is that it is possible that the column was introduced in the original data in text form. As he said, you can go ahead and change the format of the column. The second reason is when the previous column is of numeric type, but your settings don't show it as an aggregation above

If you drag a column that is not aggregated directly into the table visual object, the total will not be displayed. Of course, you can drag this non-aggregated column into the visual object and select aggregation in the drop-down options.

 

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[KK22]

Thank you Albert, for the detailed explanation. It was a teachable moment to me as well as jgeddes's reply.

[KK22]

Interesting trick, thank you for that. On formating tab I chose Decimal number, however when I clicked the Transform button the Type was Any. I changed to Decimal but unfortunately it still doesn't give me the total.

[jgeddes · Accepted solution]

One cause of this could be that there are none integer values in your March data. 
You can check this by clicking on the Transform data button and checking the data type of the March column in your table. 
If it is set as text, try and set it to decimal number. If that results in an error you will need to correct the cause of the error.