Summary Table with Sub set

[Sir_night]

I’m trying to create a summary table like the one below. It compares zones and across the business by staff rating excluding staff that are currently being trained, which is a yes no flag    

Business Area	Rating	business Zone A	business Zone B	business Zone C
Area A	all staff	12	10	9
0-2	0	1	0
Area B	all staff	13	15	16
0-2	2	3	0
Area C	all staff	15	18	18
0-2	1	6	0
Company	Total staff	40	43	43
0-2	3	10	0

[v-chuncz-msft · Accepted solution]

@Sir_night,

You may try to use Pivot Column in the Query Editor, and UNION Function in DAX.