Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix row columns without drill down

I'm working with a Matrix, wanting the row columns to not involve drill down.

For example.  A row would contain a Client Name, State, and Territory.  As this data would all involve a single record it would be visually more appealing to simply see |ABC Corp| VA| East Region|.   I've had little luck in finding out how to do this.  I've attempted turning Stepping Off which made no difference.  Any suggstions would be appreciated.  I know in Excel using a pivot table I believe the feature was called Classic Mode.

 

  • Hi Anonymous ,

     

    Right click the matrix then choose "show as a table":

    Finally you will see:

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    Hi Anonymous ,

     

    Right click the matrix then choose "show as a table":

    Finally you will see:

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!