Hello,
I have attached my data for creating the table that I need. I have also posted below how my pivot table looks in excel.
So what I do is group it by company code, then my columns include the different types of vacation accruals, this can found in the column "Accrual Code Name", and then sum by the "value" column. I need to get as close to the below table as possible, and it doesn't need to be a pivot table in Alteryx, I just need the end results like in the image below. I am pretty new to tables so any guidance would be greatly appreciated.