Conditional Column number calculation

[#1]

For each ID group in the data table, I like to calculate:

1. The count of Part Number where RANK_DESC = 1

2. The count of Part Number where RANK_ASC = 1 

   

   I like to add  two new columns PN Count of RANK_DEC =1, PN Count of RANK_ASC=1. any formulas to apply for them? 

   any other better methods to approach? thanks very much in advanced!

[#2]

welcome.