pivot using dax

Hello,

I need help with Rank and Pivot data using filters. I've attached the sample data and the result.Data (Column H,I are derived using the criteria in Col L-P))Result in Table format

Columns - A to E has actual data; H and I are derived columns based on the criteria

I was able to achieve the results using

1. Switch case in Dax to derive "Status" column

2. Using Calculated table to group and get the select order based on Min value

3. Display the data using Matrix

Issue here is with matrix, i am unable to add custom tool tip to rows and not sort based on the column data. If i can present the same via a table. I will be able to use custom tool tips and also sort the columns

I tried to use another calculated table with summarize to transform the data but it is taking a while with 500k+ rows

Thank you in advance for your help