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!