Forum Discussion
Pivot a pivot table?
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 |
1 Reply
Hi,
Next time, give a better problem description. Attached is my solution file.
Hope this helps.
