Hello, I have an issue with getting a sum from one my the child tables to provide a grand total on a group. Basically I have a grid bound to a hierarchical datasource. I then group by a field (department). Then if I drill down the parent table to access the children there is a field I want to sum up. The sum works on that level however I cannot seem to find a way to make this provide a grand total on the group and on the entire grid itself. I hope this make sense.
The next group starts here just below the "leave" child table. I would like to get a grand total on "current value" for the group (4 records in this case) . FYI, I only have this issue when using a hierarchical datasource. Thanks for your time and help.
Hello,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking through your post it seems like in our latest supported versions this feature is implemented and for every group there is summary in the grouped row, so I suggest you use some of those versions.
Feel free to write me if you have further questions.