Pivot table - double clicking on data and have results formatted with percent

Copper Contributor

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. 

2 Replies

Hi @JonathanSeymour 


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:


Sans titre.png

@L z. 


Thanks for the feedback, they should add that ability!