It's all about the answers!

Ask a question

Report Builder Report - Column Sum

Bob 3 (1481564) | asked Oct 11 '19, 1:35 a.m.
edited Oct 11 '19, 1:37 a.m.

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

We are using version

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

Bharath Rao commented Oct 15 '19, 1:56 a.m. | edited Oct 15 '19, 1:59 a.m.


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.


Bob 3 commented Oct 15 '19, 3:08 p.m.

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?

Bharath Rao commented Oct 17 '19, 2:00 a.m.

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

Bob 3 commented Oct 17 '19, 6:01 p.m. | edited Oct 17 '19, 6:01 p.m.

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