It's all about the answers!

Ask a question

Report Builder Report - Column Sum


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


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

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


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.