Crosstab with row percentage %
Does anyone know how to implement row (or column) percentages in a a crosstab table, similar to what you can do in Excel - pivot table.
Example:
Item | Value | Percentage
A | 2 | 10
B | 10 | 50
C | 8 | 40
Total | 20 | 100
Thanks!
Example:
Item | Value | Percentage
A | 2 | 10
B | 10 | 50
C | 8 | 40
Total | 20 | 100
Thanks!
Comments
this does not seem to require a cross tab.
just a 2 pass report gather totalsum in a footer band store in a variable on the final pass do the math in obp event of mdband and put the value in the last field.
I've got the same problem as Joost.
I'dont know which math function I have to use for row percentages in a crosstab table.
Could anyone give me an example how to implement the function?
@gordk
what do you mean with "do the math in obp event of mdband"? How does this work?
Many thanks
No ideas?
Does anyone know if its possible to use row percentages in cross tabs?
I want to use cross tabs because it looks better than a report with group headers etc.
It should look like this:
Item | Value | Percentage
A | 2 | 10
B | 10 | 50
C | 8 | 40
Total | 20 | 100
Maybe I can get the percentage-values by calculating with the row values like: value/totalvalue*100 = 2/20*100=10 ???
It would be great to get an answer for this problem!
Many Thanks!