Question Re: SAP Analytics Cloud sum table columns in Technology Q&A

SAP Analytics Cloud sum table columns

07makita96 — Wed, 29 Jun 2022 13:59:55 GMT

I want to sum the columns in a table in SAC Story. With the formula =sum(C3:C33) I can achieve this requirement.

But I will know, how can I add rows that will be added later to the sum?

Re: SAP Analytics Cloud sum table columns

VijayetaSharma — Wed, 29 Jun 2022 14:45:49 GMT

Hello 07makita,

If you are working with table widget or grid page you can simply add new line after your formula line. Hover around the center bottom area of table and you will notice " + =" sign.

If you are working with table widget, type of table may influence row/column addition behavior.

Don't forget to up-vote and accept, if it helped. 🙂

Vijayeta

Re: SAP Analytics Cloud sum table columns

N1kh1l — Wed, 29 Jun 2022 15:03:29 GMT

Hello Sevim,

If the formula is just to get the totals of the rows, I would suggest you to enable the Totals on the row axis of the table widget so that it can auto adjust to the addition or removal of members of the row dimension. Something like below.

Regards

Nikhil

Re: SAP Analytics Cloud sum table columns

07makita96 — Thu, 30 Jun 2022 07:25:40 GMT

Hello Nikhil,

thank you for your response. I prefer the formula calculation, because the measure "Bewerbungsstatus" from which I want the totals are in the column of the table.

By enabling the Totals, it will be shown as column not as row.

Re: SAP Analytics Cloud sum table columns

N1kh1l — Thu, 30 Jun 2022 07:30:41 GMT

Sevim,

Enable Totals on rows. i.e Stellenkennung/stellentitel. It will insert a total row at the end.

Nikhil

Re: SAP Analytics Cloud sum table columns

zee_siddique15 — Thu, 06 Jun 2024 22:16:21 GMT

Hi @VijayetaSharma, if I add a row in the end of the table , for now my table only shows 4 rows but based on the paramter change my table can grow to 10 lines, then what formula that I should write in this newly added line so that it shows me the sum of all the rows that my table will display ? I am using a table fed by two blended live models where I the table option of Arrange totals doesn't work and also the right click on each dimension show totals is also greyed out? Thanks in advance

Re: SAP Analytics Cloud sum table columns

azadanalytics — Wed, 23 Apr 2025 08:47:06 GMT

Hi,

You can calculate the row total, if you are working with table widget and also you can calculate the subtotal as well, please see below article for row calculation details steps.

https://sactutorial.com/row-calculation-in-sap-analytics-cloud/

@sapsac @07makita96