Sum of groups on line

[Anonymous]

Hi,

I have been asked to add SUM expressions onto different levels of a report, dependent on what the user selects. In the attached example I have a straight table of my weekly sales and stocks. This is divided into Category and the Group within the category. What has been requested is that the sum line exists at the change of each group, for example 'BENEFICIAL' would show £235 and 'HEALTHON' would show £2,063.

Is this possible?

Regards

David

[sunny_talwar · Accepted solution]

May be use Dimension limits tab to add totals for different dimensions.

[Anonymous]

Perfect, thank you.