Try this. It is working.
I have added a column CD with heading Total PnL & Win and Formula in CD13
=IF([@[Win/Loss (P1)]]="win",[@[Total PnL]],"")
In I6
=SUBTOTAL(101,Table13[Total PnL & Win])
Try this. It is working.
I have added a column CD with heading Total PnL & Win and Formula in CD13
=IF([@[Win/Loss (P1)]]="win",[@[Total PnL]],"")
In I6
=SUBTOTAL(101,Table13[Total PnL & Win])
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks