![Pivot data using Power Query to show text values - Data Restructuring using Excel - How To - PakAccountants.com Pivot data using Power Query to show text values - Data Restructuring using Excel - How To - PakAccountants.com](https://pakaccountants.com/wp-content/uploads/2016/07/data-restructure-1.png)
Pivot data using Power Query to show text values - Data Restructuring using Excel - How To - PakAccountants.com
![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 Display text field (no calcualtion) to a pivot table as value? - Question & Answer - Amazon QuickSight Community How to Display text field (no calcualtion) to a pivot table as value? - Question & Answer - Amazon QuickSight Community](https://d1wl4jav5dp96l.cloudfront.net/original/1X/d14862d0f0efbb789b5ab4293a39528b497f1dbe.png)