Forum Discussion
Pivot table - double clicking on data and have results formatted with percent
After creating a pivot table, when I double click on the data and a new tab is created, how do I have that data formatted already to show a percentage. My original data is in percents, and my pivot table field settings have percents already formatted on the pivot table too.
I just need the results of double clicking the values to be formatted the same once the new tab is opened.
As far as I know there's no way to get what you expect, even with a Custom Table Style as the latter only allows formatting Font, Border and Filling color:
