Spotfire - How to group multiple columns under a s

问题:

How to group multiple columns under a single column in data table visualization

Please see attached image

回答1:

@BULB - You can transform your table by unpivoting and pivoting data to get the desired result.

I first un-pivoted the original data table by applying transformation.

INSERT > Transformations

Then pivoted the unpivot output by applying another transformation.

Note: You can apply both the transformations simultaneously.

Final Output: