Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
ist there someone who would help me with me problem, please?
I have data in 3 columns: ASIN, STAR and UNITS SHIPED.
I need to select unique values from ASIN and sum UNITS SHIPED, but only for STAR = 1, 2, 3.
it looks like this:
ASIN STAR UNITS SHIPED
12 1 2
12 1 2
13 4 1
14 2 3
14 3 3
the sum that I need is 5.
I tried a lot of possibilities, but it is not work.
Thank you in advance.