Crosstab Exec Group Total

[Michael]

Hello Guys,
  I would like to access the group total value, to calculate percentages of the children elements of the group.
  In the screenshot, I would like to be able to retrieve the value 110 or 95, so I can calculate the percentages like 47/110, 24/110, 5/110, etc. for each of the rows.

  I have already tried accesing the column total using EXEC function, but it will give me the total (110 + 95), instead of the individual total.
  I tried also accesing to the specific cell textbox, but is "out of scope"

So, which would be the specific action to retrieve this value?

Thanks!

[Nasko]

Hello Michael,

In order to access the group total value you need to use the Exec function and pass to it one of the following arguments as a scope:

1. Pass the name of the appropriate group as a scope (screenshot).
2. Pass an empty string - "", which is the default scope. Then the report processor will find the nearest ancestor item defining a data scope.

Regards,
Nasko
Telerik

[Michael]

Hi Nasko, thanks for your answer! 

Unfortunately, even though what you say works for group columns, it is not what I actually need.

When I pass an empty string to the scope, I get the whole column sum total. What I need is the total for the parent group, not for all the groups.

In the screenshot I attached in my first post, i need the values 110 or 95. Using empty string I will get value 205 which is the sum of both.

Hope this clarifies the issue.

Thanks!! 

[Nasko]

Hello Michael,

Since we are not sure what is your exact group structure, please send us your report definition to review on our end.

Regards,
Nasko
Telerik