Skip to Content
avatar image
Former Member

Sum a row in vertical table

Hi,

A block (a vertical table) in my report has the following columns:

Organization | Group | Jan (MM) | Feb (MM) | ... | Nov(MM) | Dec(MM)

I would like to do a sum per row. It means adding a total column to the right of the December that sum values from Jan to Dec. It's easy to sum on a column, but it's so tricky to sum on a row.

Please help me.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 12, 2017 at 08:14 AM

    why you haven't use crosstab?

    or drag the measure object in right side column which is used to display month-wise values.

    Add comment
    10|10000 characters needed characters exceeded