BI Publisher: How to group by in data table

Question

Summary

Content

I have this data:

and I want to show the data like this:

but I insert data table using report editor, it shows as the following:

It doesn't summarize amount value.

Please suggest me.

Thanks in advance.

Thomas Dodds · Answer

Select your parent ... and set the grouping options as shown above ... if you want the summary row only, write your query to summarize before you visualize (then you aren't shipping the full volume of rows around).