Solved: View all products without duplicates - Page 2

iglonator · 03-09-2022 05:09 AM

Hi all,

I have a sheet that has:

Product A +2

Product A -1

Product B +5

Product C +7

Product B -2

Now I would like to have a view that shows totals per product:

Product A 1

Product B 3

Product C 7

Do I need to make a sperate sheet or a slice? I tried different stuff, but I'm thinking in the wrong direction. I'm probably missing something pretty easy, but I can't seem to figure it out. Thank you for your time and attention.

iglonator

Thanks for all the help guys. I've found what I needed by trying. I've found the aggregate option earlier but this is not what I wanted.

I've added the sums behind every row by selecting and summing up. Although in the view all entries were in the view so lots of duplicates. I wanted to have one entry per product and behind it to total amount. I made it work with a slice and this row filter condition:

[id] = CONCATENATE(TOP(SELECT(sheet[id], [idproduct] = [_THISROW].[idproduct]), 1))

View solution in original post