check the same workbook again in your machine. error said union must have match with same data type. your union column have problem with data type.
Glad to know that you can read the error message.
Like I said in the original post, the workbook work fine on my machine.
On the other machine, I have no problem with union. The error occurred after I pivot. I have check that all columns that I want to pivot have the same datatype Number(Decimal).