Skip to Content
Former Member
Jul 23, 2010 at 05:23 PM




I have a webi report wherein I have a section and a break applied to two different columns.

The requirement is such that I need to show the count of all the rows on the report.

I applied count function on a numeric field and I am getting counts by the column on which I have applied break and also it sums up by the coulmn on which section is applied

However I need the total count of the rows on the report. Outside the section when I apply the count function on the numeric column it does not give me total no of rows on the report.

I did try applying the sum function on the count but to no success.

Please let me know if there is a way to achieve the count of total number of rows on the report which contains a section as well as a break.

Below is the formula that I have used to get the count totals at the break and section level and it works fine.

Break Level

=Sum(Count([Re Ol]))

Section Level

=Sum(Count([Re Ol]))

I need to sum the counts that I am getting at the section level in order to render total number of rows on the report outside the section.

Please let me know on this.

Thank You,