Skip to Content
0

Sum a row in vertical table

May 12, 2017 at 07:09 AM

65

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
May 12, 2017 at 08:14 AM
1

why you haven't use crosstab?

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

Show 4 Share
10 |10000 characters needed characters left characters exceeded
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.

0

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

what is the calulation for each month variable?

0
Former Member
AMIT KUMAR

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).

0

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])

2