chaserracer83
New Member
- Joined
- Oct 8, 2012
- Messages
- 27
Hello there, I have a table in PowerPivot (let's just call it "table") and I need to create a calculated field that sums the value of field "currency" based on criteria within the table:
sum(table[currency])
Where
table[age] >9
and
table[age] < value of table[age] for the current row
and
table[product] = value of table[product] for the current row
I've found some posts with somewhat similar questions, but nothing that seems to work for this. I've tried Earlier(), SumX() with Filter()... I just keep getting errors, but I may not being using these correctly.
Thank you for you help.
Chase
sum(table[currency])
Where
table[age] >9
and
table[age] < value of table[age] for the current row
and
table[product] = value of table[product] for the current row
I've found some posts with somewhat similar questions, but nothing that seems to work for this. I've tried Earlier(), SumX() with Filter()... I just keep getting errors, but I may not being using these correctly.
Thank you for you help.
Chase