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.
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.