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

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

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

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

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
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors