Cross Tab Totals
Is is possible to see the value in the Total Element for a crosstab row from
each column in the row.
I would like to be able to do the following;
The row looks like this
Row1 10, 20, 10, 25, 35
The total for the row would be 100
(I am just using the 100 value for simplicity in explaining my situation,
the actual value could add up to whatever number)
I would like to display in the crosstab row the percentage of the total the
current column value is.
As follows:
Row1 10 10.00%, 20 20.00%, 10 10.00%, 25 25.00% , 35 35.00%
each column in the row.
I would like to be able to do the following;
The row looks like this
Row1 10, 20, 10, 25, 35
The total for the row would be 100
(I am just using the 100 value for simplicity in explaining my situation,
the actual value could add up to whatever number)
I would like to display in the crosstab row the percentage of the total the
current column value is.
As follows:
Row1 10 10.00%, 20 20.00%, 10 10.00%, 25 25.00% , 35 35.00%
This discussion has been closed.
Comments
Crosstab demos in RBuilder/Demos directory for more information.
www.digital-metaphors.com/tips/CrosstabPercentages.zip
--
Cheers,
Alexander Kramnik
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
Your solution looks promising, however I am unable to duplicate what you did
in RAP. It doesn't recognize the TppMatrix type or when I use
CrossTab1.Matrix.ColumnCount I get the error. "Expected ( or [, but found
'ColumnCount' instead"
Is your solution doable in RAP? If so how?
Bill
"Alexander Kramnik (Digital Metaphors)" wrote