It's all about the answers!

Ask a question

Report Builder Report - Column Sum

Bob 3 (146650) | 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.