Report sorting not working

Report sorting not working

I make extensive use of Summary reports and Pivot Tables.

Most of these reports are structured such that I have several columns of "information" data that I want displayed, followed by one or more "Data" summarizations.

For example, I have the following report:


However, once created, it is impossible to sort the table by anything other than "School Name", the first column in the final report. I assume because it is only sorting by the "group by" (in order), but that makes the report basically useless because there is always only one row in each group.

We want/need our end-users to be able to specify their given User Filters to narrow down to the relevant rows, then sort those by any column they wish.

There does not seem to be any way to structure either summary or pivot tables in such a way that the end-user can actually sort the finished product by any given column - which is how any spreadsheet or other data reporting system would work (and what the user would expect).

The only way around this is to manually create my entire summarization via query tables, then display the data via a "tabular" report, which is extremely time-consuming and counter-intuitive for our data team.

    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security