Quicksight not summing during groupby

Question & Answer
,
1

Hello,
In the table below, when I remove Item Id, I would expect the sum for Product to be 62, but it remains at 31, why?

image
image838×666 109 KB

Also, how do I get rid of those pesky null rows?

2

Hi @anandds - Welcome to AWS QuickSight community and thanks for posting the question. Can you please share the data types of item count, please share sample screenshot from the data set preparation page.

Regards - Sanjeeb

1 Like
3

I solved it by moving item quantity and item amount to values

2 Likes
4

Great @anandds . Good to see it resolved.

Regards - Sanjeeb