Percentage of Column Subtotal

[EpicTriffid]

Morning, I have this table:

I want to calculate the % split of UG and PG for each year. So, for example, under 18/19, I want it to say:

18/19
UG	PG
Actual	Actual
92%	8%
85%	15%
72%	28%
86%	14%

These are all single rows of data, each with a year, UG/PG status, and Actual/Target status, resulting in the format you see here. 

So, I'm guessing it needs to be a percentage of the column subtotal? But I have no idea how to do that?

[Icey]

Hi @EpicTriffid ,

It'll be great if you could provide some sample data with the same data structure of your real data for test.

Best regards

Icey

[amitchandak]

@EpicTriffid , You have % of row total in matrix visual. But I doubt that will work ,

This will be

divide([measure], allexcept(Table, Table[Year], Table[?]))

or

divide([measure], allexcept(Table, Table[Year]))

where ? is column/s on the row of the matrix

[EpicTriffid]

Hmm, that doesnt seem to be working. Screenshot of the result and measure below. Sorry for the terrible pen work!