Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
PavelR
Solution Specialist
Solution Specialist

Hi @ahsanlhcgov

 

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

 

Regards.

Pavel

View solution in original post

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

Hi @ahsanlhcgov

 

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

 

Regards.

Pavel

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.

 

 

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

 

GroupingMatrix.PNG

 

Regards.

Pavel

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. 

Do you need help?

 

You are welcome 😉

Regards.
Pavel

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. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.