Sort Report by aggregation

[David Stutter]

I have a report with Trend, Group by Company and trend by created, aggregation is count.

Is it possible to sort the graph and the display grid by the aggregation?

At the moment it is sorted by the grouped by field, in my case the companies.

I would like to have the data sorted by aggregation.

If it is not possible for the graph, than it would be helpful in the display grid.

[Rajshekhar Pau1]

Hello David,

You could have a look on this helpful link from ServiceNow documentation: Pivot tables

Let me know in case you have some query.

Hope this helps.

Please hit Like or mark Helpful or Correct based on the impact.

Thanks,

Rajshekhar Paul

[David Stutter]

Okay.

Now I can't set the row or columns to use the month of the created field.

And the problems are also the same as in the bar graph, no sort by aggregation.