cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors