Pivot Table with multiple Pivots within?

[kirbyfred94]

Hi all,

Firstly apologies if this has been asked before or if my wording is wrong, happy for any mods to correct any of this as I'm relatively new to all this.

I have the following columns in a Power Query, which is combined data from two tables which are downloaded and regularly updated using a tool called ALM, which is for testing of defects.

[TABLE="width: 1964"]
<tbody>[TR]
[TD="width: 97"]REF / ID[/TD]
[TD="width: 205"]Enhancement/Defect[/TD]
[TD="width: 104"]Status[/TD]
[TD="width: 1032"]Title[/TD]
[TD="width: 121"]Assignee.1[/TD]
[TD="width: 114"]Raised By[/TD]
[TD="width: 167"]Fixed In Release[/TD]
[TD="width: 124"]Tester[/TD]
[/TR]
</tbody>[/TABLE]

I would like to create one pivot table to display this information on a separate tab which has the following rows and columns, with the count of each status within the pivot.

[TABLE="width: 552"]
<tbody>[TR]
[TD]Status:[/TD]
[TD]Assignee 1[/TD]
[TD]Assignee 2[/TD]
[TD]Assignee 3[/TD]
[TD]Defects[/TD]
[TD]Enhancements[/TD]
[TD]Customer 1[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD]Ready To Test[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Passed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Failed Retest[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Not Delivered[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Monitor[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I can easily do this with multiple pivot tables but would rather just have one table of information displaying it. I would also rather use pivot tables as they can be clicked on to see what information is needed.

I hope that makes sense, and thanks in advance!

Fred