Question: How do you create a pivot table like this? anivettable205 prin... Set A (Last Name from A-G): Status Married Children Data Sum of Individual Estimates
anivettable205 prin... Set A (Last Name from A-G): Status Married Children Data Sum of Individual Estimates Sum of Family Estimates Sum of # Employees Sum of Individual Estimates Sum of Family Estimates Sum of #Employees Total Sum of Individual Estimates Total Sum of Family Estimates Total Sum of # Employees Single 375.75 300.65 759.00 234.07 168.67 509.00 609.81 469.32 1268.00 Grand Total 1405.65 1781.40 0.00 300.65 1592.00 2351.00 205.01 439.07 102.66 271.33 345.00 854.00 1610.66 2220.47 102.66 571.98 1937.00 3205.00 Set B (Last Name from H-M): Status Married Children No Data Sum of Individual Estimates 0 6019 Single 401.38 ] Grand Total 1183.65 1585.03 av = GW
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
