Forum Discussion

bdoiron's avatar
bdoiron
Frequent Visitor
9 years ago

Crosstab Query

  Hello all, I have a table that is unnormalized that I am trying to make a table visual from. Its values go across horizontal and I need them vertical. I can unpivot all the columns but that doesnt...
General Comment
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

bdoiron,

 

I can unpivot all and I get this:
Body position Safe           10

Body position At Risk         5

Slips Safe                         13     

Slips At Risk                       7

 

If you can get this result, you can split the first column into two colums, and then use matrix visual to get your expected results.

Descr                         Status                   Count

Body position           Safe                        10

Body position           At Risk                    5

Slips                         Safe                         13     

Slips                         At Risk                      7

 

Regards,

Charlie Liao