This was the another requirement which I had in the same report which I designed and explained in my Previous blog. Here I was required to count the total no of rows in the columns which contains the data.
I used the function ‘SUM’ under Aggregate in the Expression to count.
Then I completed the Expression with checking the Field value using IIF condition, and summing up only the fields containing data.
I was then able to calculate the sum of rows under columns containing values.
Hope this will be Helpful.