Pivot Table Help

[MisterJ2024]

Hi Everyone,

I was wondering if I could have some help with this pivot table.

The way it works now is you'll have domain 1 or domain 2 listed in the third column.

Then in the fourth column you'll have the roles associated with each domain in the fourth column being listed vertically.

I'd like to have them be listed out horizontally.

So I'll use mmoore from a spreadsheet as an example.

I'd like it to look more like this across the board.


mmoore Mary Moore Domain 2 Operations
mmoore Mary Moore Domain 1 Elevated Access Modify



I've turned off buttons on this pivot table, if that makes any difference.

I'm new to excel, so please let me know if you have any more questions.

Thanks!

 

[shift-del]

Hi MisterJ2024

"Role" is a row field - so it always fills down the rows.
But you can put it in the values area by creating a DAX measure. But your pivot must be a data model pivot. You may have to rebuild the pivot.

Pivot Table With Text in Values Area

Is there a way to show Text in the Values area of a pivot table?

www.mrexcel.com