hello
I have a count (bookings.id) as nobookings in my query, which returns a count of all specific classes for a member. In the matrix i have sum(fields!nobookings.value) which adds the bookings by class type (1 tennis, 2 golf, 3 cricket). Now i need the total of all classes by pmember (6 in this case). Can srs do this?
I assume you have a row or column grouping on the class type in the matrix, and then you get the sum of nobookings in the cells under each class type. If this is what you currently have in the matrix, just add subtotal (right-click on the row or column header, and click on subtotal) to that row or column, and you should get the total or all classes in the cells under the subtotal.|||I have the same problem, but whenever I add subtotals, the total figure is just the first value in a cell and not the total of all values. What am I doing wrong? Thanks!|||Check on the aggregate function in the expression for the cell textbox, and make sure you are using Sum() instead of First().|||I have the same problem as the subtotal only displays the first value of the row. But I could not find where is the place to change the expression. All the values below the 'Total' header in layout is greyed out and it drived me crazy. Could you please advice? Thanks a lot.|||You dont directley edit the subtotal expression.
Add the Sum() to the row\column details expression,
as the subtotal uses the expression from R/C detail
as it's own.
Hope I'm being clear enough
G
|||Thanks you so much. I think I finally got it.
No comments:
Post a Comment