cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atlihaukur
Frequent Visitor

How do I create subtotal based on calculation?

I'm trying to create a customized subtotal calculation in a table. I want to present a table like this but have not found the right formula. The challenge is to have a subtotal with a calculation A+B and have the hierarchy (sheet-Section-Line_item) working as well

 

  Value
AOperating income1700
    Net interest income1000
    Financial income600
    Net fee and commission income100
BOperating expense-800
    Other expense-300
    Salary-500
 Net Earnings before tax (A+B)1700-800=900
 Net Impairment200
      Impairment200
 Net Earningssum(value)


The data look something like this

 

Valuesheetsectionline_itemin_earnings_before_tax
-410Income statementOperating incomeNet interest income1
-128Income statementOperating incomeNet interest income1
-500Income statementOperating incomeNet interest income1
-178Income statementOperating incomeNet interest income1
-431Income statementOperating incomeNet interest income1
-251Income statementOperating incomeNet interest income1
-43Income statementOperating incomeNet interest income1
-24Income statementOperating incomeNet interest income1
-15Income statementOperating incomeNet interest income1
-58Income statementOperating incomeNet interest income1
-112Income statementOperating incomeNet interest income1
-319Income statementOperating incomeNet interest income1
-725Income statementOperating incomeNet interest income1
-121Income StatementNet ImpairmentImpairment0

 

Any help/hints would be greatly appreciated

 

1 REPLY 1
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @atlihaukur,

 

For your scenario, if you want to show the output as table, I'm afraid that we may not achieve that.

 

What about creating matrix it will show subtotal value for each level.

Capture.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors