Quicksight not summing during groupby

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?

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

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

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


Great @anandds . Good to see it resolved.

Regards - Sanjeeb