Report from Cross Table

[mkeuschn]

Hello *,

I want to create a chart with the data of a cross table. How can I accomplish this task. I have attached a excel how the chart should look like and the report file.

best regards,
Marko

[mkeuschn]

Hello,

I have found a solution. I have created a new data source from cross tab. But the Chart does not look like as expected.

regards,
Marko

Output:

Crosstab.png (19.5 KiB) Viewed 1839 times

Expected Output:

CrosstabSolution.png (10.06 KiB) Viewed 1839 times

[Alex K.]

Hello,

Can you please send us a test data for your report.

Thank you.

[mkeuschn]

Hi,

I have added a Test Project.

regards,
Marko

Actual Output

ActualOutput.png (26.17 KiB) Viewed 1836 times

Desired Output

DesiredOutput.png (11.24 KiB) Viewed 1836 times

[mkeuschn]

I have a solution. I have set the key attribute in the chart.

Key.png (13.04 KiB) Viewed 1825 times

One Problem remaining:
In the first CrossTable the Total Count is wrong. It does not sum the "count values", but it sum the "sum values".

regards,
Marko

[HighAley]

Hello, Marko.

The Chart looks right. Do you Need other values?

chart.png (20.05 KiB) Viewed 1819 times

Please, write what is wrong with this chart?

Thank you.