error in pivot column

It's a bit difficult to debug because even though you have included the pbix, we don't have access to the source spreadsheet.

You could post the spreadsheet and tell us what your desired outcome is..

Having said that, the most common pivot error is "There were too many elements in the enumeration to complete the operation".

Is that what you have?

If so, it is usually because there's no aggregation on the pivot.  So powerbi doesn't know how to cope with rows that have a similar 'key'.