This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 21%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEW%3C/text%3E%3C/svg%3E)
I have a pivot table of data where I want to show a numerical value as one of the row items. Since it is in the row item part of the pivot table, there isn't an option to control the formatting of that number. I can set the formatting manually after I refresh the pivot table, but it reverts back to the unformatted number after I refresh it again. Due to how my data is configured, I am reporting the LineVal as a row item and the OpDept data in the values section.
Hi @Eddie W. Cler ,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi @Eddie W. Cler ,
Where did get the PivotTable data source? What kind of data source did you use?
How did you create the connection?
I suggest you go to check the data source formatting and change to the formatting you need.
Then you can re-create the connection and create the PivotTable.
Any updates please let me know and I'm glad to help you.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.