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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Subtotal need to alter based on row header


I have requirement to alter my below report to show the subtotal based on Crop segement financial column level and next crop name finacial level . don't want to see in Product abbrivation , product status and product name level subtotal .

Could you please anyone suggest this ?  Because when  i  enable subtotal in matrix report default subtotal coming from last drilldown column level to each column level .issue.PNG

3 REPLIES 3
DMM
Advocate I
Advocate I

In subtotal settings, you can use the Per level option and specify which subtotals you don't want.

Anonymous
Not applicable

Thanks. But subtotal also coming one time only  at last row . It should come for all the split .

 

 

 

 

 The feature is sometimes counterintuitive because to show a subtotal at certain level, you may need to enable it at level below. If it still doesn't work, can you provide a sample file?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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