cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ahsanlhcgov Helper II
Helper II

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 Solution Supplier
Solution Supplier

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 Solution Supplier
Solution Supplier

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 Solution Supplier
Solution Supplier

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 Helper II
Helper II

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 Solution Supplier
Solution Supplier

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 Helper II
Helper II

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. 

 

ahsanlhcgov Helper II
Helper II

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. 

Highlighted
PavelR Solution Supplier
Solution Supplier

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

You are welcome 😉

Regards.
Pavel
igorabdo Advocate II
Advocate II

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

Do you need help?

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors