Crosstab - Summary Field Calculations Using Row/Column Total

[ianwelsh]

I'm using the crosstab component in a report to display a simple summation of times where the row and column conditions are met.

I would now like to add a summary field next to, or below it, showing, each value's percentage of the row total, or the summed value / overall row total (*100 as percent).

2017-12-14_11-32-40.png (48.05 KiB) Viewed 4339 times

Is this possible?

[Alex K.]

Hello,

Only with additional code in events:
https://stimulsoft.zendesk.com/hc/en-us ... -cross-tab

Thank you.

[ianwelsh]

Awesome. Thanks.

Follow up : what if one was using a cross data band? Would the solution referenced above work to reference the "next" value in a row?

[Alex K.]

Hello,

You can use the Totals.Sum or SumIf functions on the Cross-Data component.
Please check attached sample which shows how to implement Cross-Tab via Cross-Data

Thank you.

[ianwelsh]

Where can I download demo.xml/xsd for these samples? I downloaded versions from the samples section at github but when I point the reports to the downloaded files and choose "View Data" for any of the tables, I get the error:

'>' is an unexpected token. The expected token is '='. Line 42, position 91.

See attached image.

[Alex K.]

Hello,

Please check the modified report with resources directly in the report template.

Thank you.

[ianwelsh]

Thank you much, Alex.

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.

[ianwelsh]

Unfortunately, I do. I can't seem to get these cross tabs to work correctly using your file as a template/model (it was SUPER helpful though!).

I created a report demo, with dummy data, that exemplifies my confusion, which I've also tried to capture in the image below.

In short, I can't get the "data" to line up under the correct columns. I'm hoping you can point out what I'm missing!

2017-12-27_17-21-07.png (85.62 KiB) Viewed 4303 times

Thanks ahead of time.

[Alex K.]

Hello,

We need some additional time to check the issue.

Thank you.