Filter Current Month and Projected Month data

Hello,

I have a data set that tracks current month hires and terminations, and projected month hires and terminations. Ultimately, I would like to create a table similar to below/attached. The month column is written "09" for September, "10" for October, etc. I am using the summarize tool to pull data only for 09 and then another summarize tool to pull 10, I will then join them together to create the table, but stuck on writing the expression. Thank you in advance.

Group	09 Hires	Terminations	10 Hires	Terminations
A	6	1	2	0
B	5	0	1	0
C	3	2	3	0
Total	14	3	6	0

Sample Data.xlsx

Datasets

Date Time

Help

Accepted answers

rituraj963

@MChung

Try this solution and let me know if this works:

Filter Cuurent Projected Months1.yxmd

All comments

mceleavey

Hi @MChung ,

could you provide your data, or a mock up of your data so we can see what it is you're trying to do?

Thanks

rituraj963

@MChung

In you Summarize tool, Group and Month columns should have group by Action, Hires and Terminations should have Sum action. You can next use a Cross Tab tool for each measure (Hires and Terminations) and group by on Group column. Join them on record positions to get the end result.