Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Report Builder Report - Column Sum

Is there a way to create a columnar sum in a Report Builder report?

We are using version 6.0.6.1.

As drawn in the graphic, I am seeking a column total. 
Can this be done with the Report Builder wizard? If not, can it be done with custom SPARQL? (If yes, I will seek out SPARQL expertise.)

0 votes

Comments

Hi,


A similar query was answered in the below forum link:

Please review and let me know if that works for you or if you need any further assistance.

Regards,
Bharath

Bharath, thank you for your response.

I followed the instructions in the link that you provided as best I could apply them to my situation. I found that it resulted in a new column with row-based sums - not column-based sums. Any ideas for producing a column-based sum?

 Hi Bob,


I do not know of such an option available in JRS.

However, while searching for the solution, I found the below forum post which appears to be answered by you :)

Bharath, my reporting customer has returned to me, renewing their request for columnar sums. 

That is why I have submitted the question to the forum with a slightly different approach.
Thank you for your responses!


Be the first one to answer this question!

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,023
× 7,499

Question asked: Oct 11 '19, 1:35 a.m.

Question was seen: 1,770 times

Last updated: Oct 17 '19, 6:01 p.m.

Confirmation Cancel Confirm