Add a row in table to show sum of rows?

[ahsanlhcgov]

I am trying to add sum of values in a table for my income statement. 

below every group I am trying to add a SUMof values above.

The colums groupbreak have a unique combination for each group.

I am not sure how to use these.

[PavelR · Accepted solution]

Hi @ahsanlhcgov

I would recommend using Matrix visual instead of Table, then you will have required aggregations.

Regards.

Pavel

[PavelR · Accepted solution]

Hi @ahsanlhcgov

I would recommend using Matrix visual instead of Table, then you will have required aggregations.

Regards.

Pavel

[ahsanlhcgov]

i have tried the matrix visual but its the same thing. rather then adding the groups it shows the individual value as total. 

I am looking for a way to categorize the group break values and then adding ActualYTD and BudgetYTD. 

If I get that then which ever visual I use will work.

[PavelR · Accepted solution]

Maybe I don't understand clearly what you want, but what about pic below? Isn't it what you want?

Regards.

Pavel

[ahsanlhcgov]

I have created a new column and concatenated all the froup breaks and used that as a filter in matrix. Thanks alot for advising to use the correct visual. 

[igorabdo]

Do you need help?

[PavelR]

You are welcome 😉

Regards.
Pavel

[ahsanlhcgov]

yes like that.

but I have 4 groupbreak colums which work as a unique identifier to determine the category needed to be summed up. 

how did you do that, may be I can try to do the same on my data set.