Sorting and Filtering
Sorting and filtering solve different tasks. Choose the guide that matches the question you want the report to answer.
| Task | Guide |
|---|---|
| Put group names or largest totals first | Sort a Pivot report |
| Only summarize records from selected regions or products | Filter source records |
| Keep groups whose total matches a condition | Filter calculated results |
| Show the top or bottom groups | Top and Bottom Results |
Client-Side Sorting
Section titled “Client-Side Sorting”Continue with sorting.
Client-Side Filtering
Section titled “Client-Side Filtering”Continue with source filters and result filters.
What Actually Gets Sorted
Section titled “What Actually Gets Sorted”Read member and summary ordering.
Server-Side Sorting And Filtering
Section titled “Server-Side Sorting And Filtering”Read server-side request options. The backend applies ordering and filters before returning a window.
Sort By Summary
Section titled “Sort By Summary”Read summary-sort scope.
Best Practices
Section titled “Best Practices”Use source filters to change the analysis population, result filters to test summaries, and backend access checks to enforce security.
Choose fields → aggregate values → sort and filter.
Related product guides
Section titled “Related product guides”Chart data and filters use the same analytical report concepts.