- Image and text skills
Excel's Pivot Table is often used in sales work to facilitate filtering and statistics. So how to group the data in the Pivot Table?
Open a table using this sales pivot table as an example.
￭Hold [Ctrl] to select the content area to be grouped, right-click and group.
This allows you to group the contents of the pivot table.
￭So how to group dates in a PivotTable?
Place the cursor at (D7), right-click on the group, and a dialog box will pop up. We can check the required grouping by ourselves.
Have you learned this little trick?
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-jin-xing-fen-zu.html
支付宝扫一扫 
评论列表（196条）
测试