cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahsanlhcgov Regular Visitor
Regular Visitor

Add a row in table to show sum of rows?

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

 

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
PavelR Established Member
Established Member

Re: Add a row in table to show sum of rows?

Hi @ahsanlhcgov

 

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

 

Regards.

Pavel

View solution in original post

PavelR Established Member
Established Member

Re: Add a row in table to show sum of rows?

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

 

GroupingMatrix.PNG

 

Regards.

Pavel

View solution in original post

7 REPLIES 7
PavelR Established Member
Established Member

Re: Add a row in table to show sum of rows?

Hi @ahsanlhcgov

 

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

 

Regards.

Pavel

View solution in original post

ahsanlhcgov Regular Visitor
Regular Visitor

Re: Add a row in table to show sum of rows?

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 Established Member
Established Member

Re: Add a row in table to show sum of rows?

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

 

GroupingMatrix.PNG

 

Regards.

Pavel

View solution in original post

ahsanlhcgov Regular Visitor
Regular Visitor

Re: Add a row in table to show sum of rows?

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. 

 

Highlighted
ahsanlhcgov Regular Visitor
Regular Visitor

Re: Add a row in table to show sum of rows?

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. 

PavelR Established Member
Established Member

Re: Add a row in table to show sum of rows?

You are welcome 😉

Regards.
Pavel
igorabdo Regular Visitor
Regular Visitor

Re: Add a row in table to show sum of rows?

Do you need help?

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 157 members 2,106 guests
Please welcome our newest community members: