SAP Analytics Cloud sum table columns

[07makita96]

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?

[N1kh1l · Accepted solution]

Sevim,

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

Nikhil

[N1kh1l]

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

[07makita96]

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.

[VijayetaSharma]

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

[zee_siddique15]

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

[azadanalytics]

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