# Raw Data Explorer options for aggregating (calculations), grouping & sorting results **URL:** \ **Category:** Ideas & feature requests\ **Tags:** idea-completed\ **Created:** [15 November 2024 14:53 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208 "2024-11-15T14:53:06Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [15 November 2024 14:53 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/1 "2024-11-15T14:53:06Z")
This feature request is to add some new features to the Raw Data Explorer, namely: - **Aggregating (calculations):** For example, average, sum, row count, etc. - **Grouping:** For example, grouping the “Products sold (order lines)” report to give one row per order. This would work well with aggregating/calculations. - **Sorting:** Choose your own order for the results to show. - **Filtering on Aggregating/calculations:** For example, if you group rows in the order lines report by order, you could filter to show just orders with a total product quantity of more than 5. - _Possible bonus feature:_ **Aggregating (with calculations using multiple fields)**: For example, `quantity_dispatched - quantity_returned` on the _Products sold_ report. This may not make it into the first version of this feature, but it’s worth considering when we make the final preparations for this build, so I wanted to note it here too. ---
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [15 November 2024 14:54 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/2 "2024-11-15T14:54:09Z")
I’m merging in below here a thread on sorting results in the Raw Data Explorer. This will ensure the votes are transferred to this thread. If anyone else would like to see these improvements to the Raw Data Explorer, please give this thread a vote. ---
**Author:** ![chris-squires1](https://community.breww.com/user_avatar/community.breww.com/chris-squires1/32/1936_2.png) [@chris-squires1](https://community.breww.com/u/chris-squires1)\ **Post date:** [19 September 2023 16:05 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/3 "2023-09-19T16:05:23Z")
It would be very useful to sort data when pulling reports via the Raw Data explorer, like one can do in other reports. Often, the report has everything I want to see but isn’t sortable, so I have to export to a spreadsheet just to sort data that’s already on the screen. ---
**Author:** ![ellen-mills](https://community.breww.com/user_avatar/community.breww.com/ellen-mills/32/2982_2.png) [@ellen-mills](https://community.breww.com/u/ellen-mills)\ **Post date:** [5 February 2024 15:02 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/4 "2024-02-05T15:02:50Z")
This would be really useful to see as a standard option on all the reporting functions ---
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [12 January 2026 11:01 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/6 "2026-01-12T11:01:25Z")
We’re delighted to announce a major update to the Raw Data Explorer 🎉 Today we’ve added: - **Group by functionality** - Group report results by selected fields - **Aggregation mode** - Apply calculations (Sum, Average, Min, Max, Count, Count distinct, Concatenate, etc) to fields - **Sortable results** - Sort directly in Breww without exporting to Excel For more on how this works, please see the [Raw Data Explorer help guide](https://breww.com/docs/aggregate-and-raw-data-explorer-reports/#raw-data-explorer). Enjoy the new reporting super-powers 🦸 ---
**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\ **Post date:** [17 January 2026 11:02 UTC](https://community.breww.com/t/raw-data-explorer-options-for-aggregating-calculations-grouping-sorting-results/5208/7 "2026-01-17T11:02:16Z")
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.