Total on abreak

[Former Member]

Hi Guys, I created a break and sorted the report on months, I right click on a measure column, calculate / sum but I am getting the total sum not the break sum, how can I place the sum on the break.

Thanks

[Former Member · Accepted solution]

Hi,

The calculation(sum in this case) can be done on two level.

Break level and Table level

I think you have put the summation formula on the table footer, and not on the break footer.

To determine, where you have placed the formula. first select the table and go to the properties. check fiels "Show table footers". if its checked then the formula placed is on the table footer.

Secondly go to the column on which you put the break, then go to the prperties of the break and check if you have selected the fooetr here as well.

Hope it clarifies your dilemma.

Regards,

Nisha

[Former Member]

You can use Calculation Contexts here. (ForEach, ForAll and In) to get Break sum.

Eg:

In total column : =Sum((<Measure Object>) froeach <break applied dimension object>) In report --(if needed use this)

Closing of braces will matters, if it is out of Context change the braces preference.

Hope it should helps you.

Thank You!!

[Former Member]

Are you working in Webi? If so, does your formula on the break footer row look like "Sum([object_name])"?