Forum Discussion
Anonymous
6 years agoNot applicable
How to group from multiple values
Please help to get this output
| P1 | PT |
| P2 | PT |
| P3 | PT |
| P4 | PT |
| P5 | P5 |
3 Replies
- az38Community Champion
Anonymous
what rules?
Column = IF([Column1] = "P5", "P5", "PT") - AnonymousNot applicable
Thank you further help me
Columns i have in my table :
Col1 Col2 Values P1 Pt 10 P2 pt 20 P3 Pt 30 P4 Pt 40 P5 P5 50 Output
PT 100 P1 10 P2 20 P3 30 P4 40 P5 50 With grouping
- az38Community Champion
Anonymous
just create a matrix visual as follow: