Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to group from multiple values

Please help to get this output

 

P1PT
P2PT
P3PT
P4PT
P5P5

3 Replies

  • az38's avatar
    az38
    Community Champion

    Anonymous 

    what rules?

    Column = IF([Column1] = "P5", "P5", "PT")
  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you further help me

     

    Columns i have in my table :

    Col1Col2Values
    P1Pt10
    P2pt20
    P3Pt30
    P4Pt40
    P5P550

     

    Output

    PT100
      P110
      P220
      P330
      P440
    P550

     With grouping

    • az38's avatar
      az38
      Community Champion

      Anonymous 

      just create a matrix visual as follow: