Forum Discussion

awitt's avatar
awitt
Helper III
7 years ago
Solved

Sort filtered column by another column value.

How do i seperate the far right column to show the sum per order # instead of the total for both? All of the values in "Column" for Order# 10001 should be 10 and 10002 should be 12.      
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

     

    Try this :

     

    Column = CALCULATE(SUM(Table1[Revenue]),ALL(Table1), Table1[Order#]= EARLIER(Table1[Order#]), Table1[Item Version]="S")

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Got it (I think):

Column =
CALCULATE (
    SUM ( Sheet2[Per Item Revenue] ),
    FILTER (
        Sheet2,
        Sheet2[Order #] = EARLIER ( Sheet2[Order #] )
            && Sheet2[Item Version] = "S"
    )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Good job Anonymous , Your logic was right, just syntax needed some correction.

 

Thanks

Raj