Forum Discussion

mterry's avatar
mterry
Helper V
8 years ago
Solved

Creating columns from row values

I tried using unpivot, but that doesn't seem to be working (or I'm not using it correctly).  Here's a description of my issue: I have a column with many company divisions, another column with region...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I dont think that is possible in a matrix visual.  In a matrix visual, you can sort by the Grand Total column (not by individual columns).

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi mterry,

 

The Matrix will be very helpful in your scenario. 

1. Do you want a calculated table?

2. What kind of sort do you want?

 

Best Regards,

Dale