Profit and Loss

Question

Morning, I am creating a profit and loss.

I have Indexed or categorised my amounts into income and expenses etc.

However how do I get subtotals to add or subtract.

Disclaimer - new to BI

Eg Sum index 1 plus sum index 2

danextian · Answer

Hi Babycakes ,
&nbsp;
Please share a sample data and your expected result.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2754536#M958774

v-zhangti · Answer

Hi,&nbsp;Babycakes&nbsp;
&nbsp;
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.
&nbsp;
Best Regards,
Community Support Team _Charlotte
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

babycakes · Answer

Thank you&nbsp;&nbsp;I have attached.I am trying to acheive the sub totals to appear for example Total Governtment Funding is B16 plus B15 in my template uploaded to Power bi but the matrix is not allowing the measure to add.

babycakes · Answer

Total Government Funding B17&nbsp;B16+B15&nbsp;&nbsp;&nbsp;Total Income&nbsp;(B2:B12)+B17&nbsp;Line ItemLine Item DescriptionLevelHighlightAccount Code1IncomeIncome1&nbsp;2A incomeTotal Income0&nbsp;3B IncomeTotal Income0&nbsp;4C IncomeTotal Income0&nbsp;5D IncomeTotal Income0&nbsp;6E IncomeTotal Income0&nbsp;7F IncomeTotal Income0&nbsp;8G IncomeTotal Income0&nbsp;9H IncomeTotal Income0&nbsp;10I IncomeTotal Income0&nbsp;11J IncomeTotal Income0&nbsp;12&nbsp;Total Income0&nbsp;13&nbsp;&nbsp;&nbsp;&nbsp;14Government FundingGovernment Funding1&nbsp;15A Govt&nbsp;Total Government Funding0&nbsp;16B GovtTotal Government Funding0&nbsp;17Total Government FundingTotal Income1&nbsp;18&nbsp;&nbsp;&nbsp;&nbsp;19Total IncomeTotal Income1&nbsp;20&nbsp;&nbsp;&nbsp;&nbsp;

babycakes · Answer

See above

Forum Discussion

Profit and Loss

6 Replies

Related content

Profit and Loss Reports

How to create dynamic / special profit and loss

Profit & Loss Table

Profit and Loss

Calculate Gross margin in Profit and Loss statement

Line Item	Line Item Description	Level	Highlight	Account Code
1	Income	Income	1
2	A income	Total Income	0
3	B Income	Total Income	0
4	C Income	Total Income	0
5	D Income	Total Income	0
6	E Income	Total Income	0
7	F Income	Total Income	0
8	G Income	Total Income	0
9	H Income	Total Income	0
10	I Income	Total Income	0
11	J Income	Total Income	0
12		Total Income	0
13
14	Government Funding	Government Funding	1
15	A Govt	Total Government Funding	0
16	B Govt	Total Government Funding	0
17	Total Government Funding	Total Income	1
18
19	Total Income	Total Income	1
20