- Image and text skills
The "Options" of the Pivot Table can set the layout format, summary filtering, display and data of the Pivot Table.
▪Taking this pivot table as an example, we can see that the pivot table contains incorrect values.
How to hide or customize the error value display style?
After inserting the pivot table, click Analysis-Options in the upper menu bar, and the "Pivot Table Options" dialog box will pop up.
In Layout and Format, check the format "For error values, display" and enter the display content, so that you can customize the display style of error values.
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/ru-he-yin-cang-huo-zi-ding-yi-she-zhi-shu-ju-tou-shi-biao-de-cuo-wu-zhi.html
支付宝扫一扫 
评论列表（196条）
测试