Dear All,
I have a problem. I need to use SUMIF'ish function in PowerPivot that would go something like this.
A 1
B 2
C 3
A 10
A 50
B 60
B 10
And for this Data I would like to get
A 61
B 72
C 3
A 61
A 61
B 72
B 72
So it would be a sumif with changing criteria for each row. How to solve this? Thanks guys !
I have a problem. I need to use SUMIF'ish function in PowerPivot that would go something like this.
A 1
B 2
C 3
A 10
A 50
B 60
B 10
And for this Data I would like to get
A 61
B 72
C 3
A 61
A 61
B 72
B 72
So it would be a sumif with changing criteria for each row. How to solve this? Thanks guys !