on 07-23-2010 5:04 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.
Thank You,
boe user
Hi,
You need to use context.
example
Table
State / Lines/ Sales Revenue
Break in State
and apply this formula to count the lines.
=Count([Lines];All) ForAll([State])
Regards.
Yudel Vives
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.