Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Cross Tab Totals

edited April 2002 in General
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%

Comments

  • edited April 2002
    Please see the demo below for an example of how to do this. Also see the
    Crosstab demos in RBuilder/Demos directory for more information.

    www.digital-metaphors.com/tips/CrosstabPercentages.zip

    --
    Cheers,

    Alexander Kramnik
    Digital Metaphors

  • edited April 2002
    Alexander,
    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
This discussion has been closed.