![The excel "Amount" Column I had convert to Number, however, it display as text, and it cannot sum when I create pivot table, who can help me solve this issue? - Studio - The excel "Amount" Column I had convert to Number, however, it display as text, and it cannot sum when I create pivot table, who can help me solve this issue? - Studio -](https://global.discourse-cdn.com/uipath/original/4X/3/5/0/3505e454952838452bdbcbb2e7d7d97a4dca42fd.png)
The excel "Amount" Column I had convert to Number, however, it display as text, and it cannot sum when I create pivot table, who can help me solve this issue? - Studio -
![How to add a variance and running total in a Pivot Table - Excel Tips & Tricks - Site Help - Community Hub How to add a variance and running total in a Pivot Table - Excel Tips & Tricks - Site Help - Community Hub](https://communityhub.sage.com/cfs-filesystemfile/__key/communityserver-components-sitefiles/BI-2018-08/Image_2D00_1.png)
How to add a variance and running total in a Pivot Table - Excel Tips & Tricks - Site Help - Community Hub
![How to add a field to a PivotTable from the Report Manager - Sage Intelligence Tips & Tricks - Site Help - Community Hub How to add a field to a PivotTable from the Report Manager - Sage Intelligence Tips & Tricks - Site Help - Community Hub](https://communityhub.sage.com/resized-image/__size/640x480/__key/communityserver-blogs-components-weblogfiles/00-00-00-01-27/1541.pastedimage1570008384533v1.png)