Sum a row in vertical table

[Former Member]

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.

[amitrathi239]

why you haven't use crosstab?

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

[Former Member]

That is the existing report and I am not the creator. I receive the requirement to add a column to the right of December that sum values from Jan to Dec.

I do search and see the crosstab solution, but I cannot change the layout of the report.

[amitrathi239]

do you have values for more then month Jan to Dec in report?

what is the calulation for each month variable?

[Former Member]

No calculation is needed because each month is a object in the query, just put it in the block along with other objects (org, group, etc).

[amitrathi239]

insert one more column in right and add all month objects to get the total for all.

Total=Sum([Jan Measure]+[Feb Measure]+[March Measure])