Jan 29 2022 09:03 AM
Just purchased Office 2021 (Mac) - on the PC version for pivot tables - in the "Field Settings", under the "Layout & Print" tab, there is a "Show items labels in tabular form" - is this function available in the Mac version - I cannot find it?
If not is there anyway to accomplish the same via a different method on the Mac version
Jan 29 2022 09:20 AM
@Boz-1 When inside a pivot table, the Design tab in MS365 contains the option you seek under the Report Layout icon. I guess it's the same in 2021.
Jan 29 2022 09:27 AM
Jan 29 2022 09:32 AM
@Boz-1 Don't know what you mean. Sorry. Can you show? Upload a screenshot of what you see on a PC.
Jan 29 2022 09:49 AM
Jan 29 2022 09:55 AM
Jan 29 2022 10:09 AM
Jan 29 2022 10:12 AM
Jan 29 2022 11:04 AM
@Boz-1 See attached for the closest I can get on a Mac just now.
Jan 29 2022 11:10 AM