Forum Discussion

luis_pflucker's avatar
luis_pflucker
Icon for Helper II rankHelper II
5 years ago

how to group rows with calculated columns

Hi, I have a table with calculated columns  as you see in the attached picture, I am trying to group in same row for example Defect ID 32013, 32026, 32053, etc where as a result the column #TCs Bloc...
Need Help
MPMP's avatar
MPMP
Frequent Visitor
5 years ago

You need to create another column and get the MaxRank in each group, if the max rank = 0 then 'N' if the max rank =1 then 'Y'

MPMP's avatar
MPMP
Frequent Visitor
5 years ago

Hi Luis,

I hope my solution helped you to achieve what you were looking for, could you please accept it as solution ?

  • luis_pflucker's avatar
    luis_pflucker
    Icon for Helper II rankHelper II
    5 years ago

    Hi, I am still trying to figure out gow to apply your suggestion.