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
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
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.