Forum Discussion
Percentage Format from Data Model not reflecting in pivot table
Hi there I have set up a data model from which I have created a pivot table. I have fields where the data type format in the data model is percentage. This format reflects in the field filter drop d...
AntrikshSharma
Community Champion
Community Champion0.5, 0.1, 0.75 are decimal numbers so their percentage counterparts would be 50%, 10%, and 75%
The problem is my decimals are 0.0010, 0.0020, .....0.0100, 0.0125,00.0150 that I want to display as 0.10%, 0.20%, ....1.00%, 1.25%, 1.50%, etc.
Do you know how I could achieve that?
Thanks again for all your assistance.