Categorical Summary

Categorical Summary helps you group and summarize data by specified fields in WPS Sheets. It provides the tools you need to calculate grouped results with Sum, Count, Average, Max, and Min, making your work more efficient and helping you accomplish tasks with ease. With Categorical Summary, you can group data by a selected column, apply one or more summary calculations to chosen data columns, generate hierarchical summary reports, create multi-level nested summaries by keeping existing subtotal results, and remove all summaries to restore the original data. Whether you're reviewing grouped data, building layered summary reports, or copying only visible summary cells without hidden detail rows, Categorical Summary helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53