In Matrix Combine a column 'Budget' at top level then second level column Actual

[daniberes]

I need to have one column in the matrix that will show the budget total above the group of values

Right now it is in its own column. See below, first column is budget, I want move that TOTAL into same column as Actual as a header then subtract and difference below level 

I am just stuck, I feel like it should not be that hard but I cant wrap my head around it.

Any suggestions would be apprectiated.

[Anonymous]

Hi @daniberes 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

Thank you very much for your kind cooperation.

If not, you can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@daniberes can you share the sample raw data? The solution will depend on that.

[daniberes]

Let me trim down my report

Or create a copy with fake numbers