- Image and text skills
In commodity sales work, we often encounter the need to calculate and collect sales.
How to set and modify the calculated fields of the pivot table?
▪Take this pivot table as an example.
We can see that the number of products is listed as a summation item, that is, the total number of all products is calculated. So how to count how many products there are?
Select the quantity column, click Analysis-Field Settings, and in the pop-up "Value Field Settings", select the value field summary method as "Count".
This way we can clearly and intuitively see how many types of products there are.
▪Similarly, we can also quickly set the total sales volume, average value, maximum value and minimum value of sales.
Have you learned this practical skill?
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-ru-he-she-zhi-shu-ju-tou-shi-biao-de-ji-suan-zi-duan.html
评论列表(196条)
测试