on 07-23-2010 6:23 PM
Hi,
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,
boeuser
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.