Showing results for 
Search instead for 
Did you mean: 


Former Member
0 Kudos


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,


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

See if you get an answer in the [webi|; forum