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

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

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

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

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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors