I recently moved to a Mac computer at work and cannot figure out how to mix report layouts in a pivot table.
Is this feature available in Excel for Mac?
For example I want my report layout mix compact and tabular:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer
[/TD]
[TD]Year
[/TD]
[TD]State
[/TD]
[TD]Product
[/TD]
[/TR]
[TR]
[TD]Customer A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Widget X
[/TD]
[TD]2019
[/TD]
[TD]MO
[/TD]
[TD]Product A
[/TD]
[/TR]
[TR]
[TD] Widget Y
[/TD]
[TD]2018
[/TD]
[TD]IL
[/TD]
[TD]Product B
[/TD]
[/TR]
</tbody>[/TABLE]
Is this feature available in Excel for Mac?
For example I want my report layout mix compact and tabular:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer
[/TD]
[TD]Year
[/TD]
[TD]State
[/TD]
[TD]Product
[/TD]
[/TR]
[TR]
[TD]Customer A
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] Widget X
[/TD]
[TD]2019
[/TD]
[TD]MO
[/TD]
[TD]Product A
[/TD]
[/TR]
[TR]
[TD] Widget Y
[/TD]
[TD]2018
[/TD]
[TD]IL
[/TD]
[TD]Product B
[/TD]
[/TR]
</tbody>[/TABLE]