Forum Discussion
PantherusNZ
4 years agoHelper I
Display Data in Table/Matrix based on variable filters
I have a data dump of a large number of line items, and am trying to display them all in a single table based on various filters. Each line item, among other things, has 4 colums I'm interested i...
amitchandak
4 years agoSuper User
PantherusNZ , You can unpivot the Response SLA ,Restore SLA and Not-At-Fault. And then create a column of yes and using if or switch
PantherusNZ
4 years agoHelper I
Hi amitchandak
I'm trying to follow your instructions but I must be doing something wrong.
I selected the 3 colums and pivoted them but it just duplicated each row of data 3x with the 3 columns added with their yes/no values...I am either doing something wrong or just don't know where to go from there.