Still a newbie trying to figure things out.... how can I transform multiple rows of data into one and also add new columns to the single row with data from the multiple rows?
Thanks in advance for any help or suggestions!
Odd that we can't download.
I chose to use a Summarise over a formula so it would just keep working regardless of number of months or when the months change.
First thought was a formula tool but felt a summarise would be a more general solution.
You are right @jdunkerley79..using summarize tool will make it generic regardless of how many months are there.
Awesome - learned a lot today! Thanks everyone!!
I still can't download... :-(
If you get a chance, I'd be interested in seeing how you configured the Summarize tool to compare to the Formula tool.
Cross tab config will be same and for summarize tool do group by EmpID and use Sum and Average actions for hours field. then use a join tool to combine Cross tab and Summarize inputs on EmpID.
Config all three tools below:
Yes, I was doing the same as this :)