How do I create subtotal based on calculation?

[atlihaukur]

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
A	Operating income	1700
	Net interest income	1000
	Financial income	600
	Net fee and commission income	100
B	Operating expense	-800
	Other expense	-300
	Salary	-500
	Net Earnings before tax (A+B)	1700-800=900
	Net Impairment	200
	Impairment	200
	Net Earnings	sum(value)

The data look something like this

Value	sheet	section	line_item	in_earnings_before_tax
-410	Income statement	Operating income	Net interest income	1
-128	Income statement	Operating income	Net interest income	1
-500	Income statement	Operating income	Net interest income	1
-178	Income statement	Operating income	Net interest income	1
-431	Income statement	Operating income	Net interest income	1
-251	Income statement	Operating income	Net interest income	1
-43	Income statement	Operating income	Net interest income	1
-24	Income statement	Operating income	Net interest income	1
-15	Income statement	Operating income	Net interest income	1
-58	Income statement	Operating income	Net interest income	1
-112	Income statement	Operating income	Net interest income	1
-319	Income statement	Operating income	Net interest income	1
-725	Income statement	Operating income	Net interest income	1
-121	Income Statement	Net Impairment	Impairment	0

Any help/hints would be greatly appreciated

[v-piga-msft]

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.

Best  Regards,

Cherry