Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Basic Table

MOlinski
7 - Meteor

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.

 

MOlinski_0-1652130221835.png

1 REPLY 1
DataNath
17 - Castor

Think I've managed to get the table you're after. There are a small number of values out by a few cents but from a search of the .xlsx it looks like the sample data is slightly different to that used for the desired output so likely the cause!

 

DataNath_0-1652131735116.png

 

Edit: Table tool added

 

DataNath_0-1652131903658.png

 

 

Labels