Sum Values - calculation field problem

Hi all, I’m facing some calculation problems in Quicksight.

Here is an example:
image
in my original data, the sum of Misscans on week 13 is 63, and if I use the sum of Misscans in my dashboard in Quicksight, I will get different and larger data:
image
image

How can I just calculate the sum of misscans of specific week? Is there any solution to solve this problem?

Thanks in advance!

Hi,

Add week column in group value.

regards,
Naveed Ali

Hi @Naveed , thanks for your answer! if i understand correctly, I have already added Week column and doesn’t work.