samdthompson
New Member
- Joined
- May 1, 2018
- Messages
- 14
Hello, I have excel 2016 pro plus (not 365). I have an option (3rd from top) when I right click on a pivot table which says 'Tabular, no-subtotals layout'. Don't get me wrong, I love it but I am completely lost as to how I got it. I must have changed something at some point but as far as I know, its not a feature of 2016 pro plus. Anyone know how I might have got the option?.
It doesn't matter what the source of the pivot table, data model, SSAS, PBI, tables etc. Have hunted through every setting I can think of and even stumbled through the updates log. nothing rings a bell.
Cheers,
Sam
It doesn't matter what the source of the pivot table, data model, SSAS, PBI, tables etc. Have hunted through every setting I can think of and even stumbled through the updates log. nothing rings a bell.
Cheers,
Sam