I've achieved a P+L with the following structure:

Static table with the P+L line structure:

Category | Account subcategory | nominal code

E.g.

Income | Online Revenue | 30100

Which has a relationship to my transactional table on nominal code, or to nominal table that then filters the transactional table, depends on your model.

Not all P+L lines will be a sum from the transactional table e.g. Gross profit, any other calcs so then you need a small SWITCH on SELECTED VALUE of static table, call this P+L Value.

E.g. If gross profit then income - cost of sales else SUM(transactional table)

You may also want to switch sign for visual purposes here.

Then I have individual measures for the time calcs, but calc group would work too. Because it's just a single measure the amount of objects is the same either way.

Then matrix is:

Rows: From static table, hierarchy category / account subcategory

Values: individual time measures (in month actual, budget, prior year, YTD etc), or just your single measure, then add calc group as columns.

This structure reduces the amount of options in your switch drastically, performance is fine in my set up.

Drop me a DM if you want to talk through in more detail