I have a really simple Pivot Table, with a standard calculated field (summarize values by sum, but show as percentage of parent row total).
When I save & close the file, and reopen and refresh, the 'show as percentage of parent row total' disappears, showing the values as a simple sum, not %.
- The 'preserve cell formatting on update' is checked.
- I've tried to define the Number Format of this value as percentage, but this get's lost every time I re-open as well.
Do you have any ideas how I could make sure the formatting won't be changed after re-opening & refreshing?
This has become a huge pain, since I created many tabs from this one PivotTable (using Report Filter Pages), and I end up having to change them constantly.
Any help will be greatly appreciated
Thank you so much in advance