:Examples and Applications of Pivot Tables How to Modify the Order of Rows and Rows in Pivot Tables-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Examples and Applications of Pivot Tables How to Modify the Order of Rows and Rows in Pivot Tables

Examples and Applications of Pivot Tables How to Modify the Order of Rows and Rows in Pivot Tables

Author: daogeziyuan • • Table skills • Views 579
  • Image and text skills


In life and work, we often use pivot tables in EXCEL tables for filtering and statistics.

So how to modify the order of rows and columns of PivotTable data?

Taking this sales table as an example, how to modify the column order of sales volume, quantity, and unit price?


微信截图_20190520114340.png

分界线.png

￭Place the cursor at (A6), right-click and select "Move" - ​​"Move Salesperson Down".

We can then move the "Salesperson" field below.


数据透视表如何修改行列字段顺序1.gif


￭We can also use the "PivotTable Area" on the right to move, and we can drag the fields freely in "Value".

Drag the quantity above the sales volume to modify the column order of sales volume, quantity, and unit price.


数据透视表如何修改行列字段顺序2.gif


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-ju-tou-shi-biao-shi-li-yu-ying-yong-shu-ju-tou-shi-biao-ru-he-xiu-gai-hang-lie-zi-duan-shun-xu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 中国 Columnist
48 196
single-end

Related Suggestion