Crosstab - Summary Field Calculations Using Row/Column Total
Crosstab - Summary Field Calculations Using Row/Column Total
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).
Is this possible?
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).
Is this possible?
Re: Crosstab - Summary Field Calculations Using Row/Column T
Hello,
Only with additional code in events:
https://stimulsoft.zendesk.com/hc/en-us ... -cross-tab
Thank you.
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
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?
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
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.
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.
- Attachments
-
- CrossTabvsCrossDataReport.mrt
- (38.19 KiB) Downloaded 368 times
Re: Crosstab - Summary Field Calculations Using Row/Column T
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.
'>' is an unexpected token. The expected token is '='. Line 42, position 91.
See attached image.
- Attachments
-
- Error
- 2017-12-26_14-42-24.png (53.59 KiB) Viewed 4327 times
Re: Crosstab - Summary Field Calculations Using Row/Column T
Hello,
Please check the modified report with resources directly in the report template.
Thank you.
Please check the modified report with resources directly in the report template.
Thank you.
- Attachments
-
- CrossTabvsCrossDataReport2.mrt
- (808.08 KiB) Downloaded 445 times
Re: Crosstab - Summary Field Calculations Using Row/Column T
Thank you much, Alex.
Re: Crosstab - Summary Field Calculations Using Row/Column T
Hello
We are always glad to help you!
Please let us know if you need any additional help.
Thank you.
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
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!
Thanks ahead of time.
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!
Thanks ahead of time.
- Attachments
-
- Data.xlsx
- Data
- (9.82 KiB) Downloaded 201 times
-
- Report.mrt
- Report
- (10.68 KiB) Downloaded 319 times
Re: Crosstab - Summary Field Calculations Using Row/Column T
Hello,
We need some additional time to check the issue.
Thank you.
We need some additional time to check the issue.
Thank you.