Pivot a pivot table?

[paxdolphin]

Hi,

How do i use power bi to come with the 2nd table from the first table?  Thank you.

Project	Report
A	A1
A	A2
A	A3
B	B1
B	B2
C	C1
C	C2

No. of Reports	No. of Projects
2	2
3	1

[Ashish_Mathur]

Hi,

Next time, give a better problem description.  Attached is my solution file.

Hope this helps.