Page 1 of 1
Crosstab - Summary Field Calculations Using Row/Column Total
Posted: Thu Dec 14, 2017 4:35 pm
by 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 5831 times
Is this possible?
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Sat Dec 16, 2017 8:17 am
by Alex K.
Hello,
Only with additional code in events:
https://stimulsoft.zendesk.com/hc/en-us ... -cross-tab
Thank you.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Tue Dec 26, 2017 3:34 pm
by 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?
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Tue Dec 26, 2017 7:33 pm
by 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.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Tue Dec 26, 2017 7:45 pm
by 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.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Wed Dec 27, 2017 2:54 pm
by Alex K.
Hello,
Please check the modified report with resources directly in the report template.
Thank you.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Wed Dec 27, 2017 4:14 pm
by ianwelsh
Thank you much, Alex.

Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Wed Dec 27, 2017 9:20 pm
by Alex K.
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Wed Dec 27, 2017 10:28 pm
by 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 5795 times
Thanks ahead of time.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Posted: Wed Jan 03, 2018 6:58 am
by Alex K.
Hello,
We need some additional time to check the issue.
Thank you.