Export data to Excel with “lowest level” summary data only

You create an Activity code to group data as you wish. After assigning and grouping activity by Activity code, here is the result:

You want to export only the summary data to excel. So we will tick the “Show Summaries Only” option.

However, you only want to export summary data at the lowest level. Because if you export all level, then in excel if you sum the value, it is a wrong number.

So, how can we show only summary data at the lowest level. The “high level” summary data should be zero.

Here is the solution.

In the Group & Sort dialog, you deselect the “Indent” option:

Now the summary data only appear at lowest level: