Post reply

Matrix - converting rows to percentage of column total

  • May 24, 2005 at 1:24 am

    #163835

    Hello!

    Given a column with a total at the bottom, how do you change the values in that column to percentages of the total?

    Aaaaaarrrrrrrrgggggggghhhhhhhhh

    can you feel the frustration?

  • May 24, 2005 at 9:06 pm

    #560880

    You could try adding a static column to the matrix and then changing the row value to along the lines of

    = ReportItems!txtMyField.Value / SUM(Fields!myField.Value, "myDataRegion")

    and then format the textbox with the 'p' format code (for percentage).

     

    Steve.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply