I have what's probably a simple BO question for most of you - I'm pretty new to BO, so please bear with me.
I have two rows I want to summarize together, though a column might have two separate values (which I want to hide, anyways). Here's a structural example:
Bob Y 1
Bob N 2
(is what I have)
Bob 3
(is what I want)
So basically I want one row for "Bob", and I don't care about the "Y,N" column, and then I want to sum the third column so I have only two columns left.
Any help is appreciated. Thanks in advance!
I have two rows I want to summarize together, though a column might have two separate values (which I want to hide, anyways). Here's a structural example:
Bob Y 1
Bob N 2
(is what I have)
Bob 3
(is what I want)
So basically I want one row for "Bob", and I don't care about the "Y,N" column, and then I want to sum the third column so I have only two columns left.
Any help is appreciated. Thanks in advance!