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

awitt's avatar
awitt
Helper III
7 years ago

Still getting the total revenue for all "s" revenue instead of it sorting by Order #. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

Try this :

 

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

Thanks
Raj

  • awitt's avatar
    awitt
    Helper III
    7 years ago

    Awesome, thanks!