Matrix row columns without drill down

[Anonymous]

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.

[v-kelly-msft · Accepted solution]

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!