This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The columns in the output of the cross tab tool are dependent on the values that are present in the column that's used as the Change Column Headers. If Sum_17 is not a value in the column, it won't show up as a column. The way to get around this is the calculate the L5A SA column before you Cross Tab.
1. Use a filter to get the values that correspond to the Sum_5 - Sum_24 rows. Something like Name in ("Sum_5", "Sum6",...,"Sum_24"). The filter will only return the rows that exist and, importantly, not error on the missing ones.
2. Add a Summarize tool that groups by all the key columns in your Cross tab to add up the Sum_X values and rename the sum column the same as the column you're using as the Values column in the Cross tab.
3. Use a formula tool to add a column to the output of the summarize called the same as the "Change Column Headers" column and set the formula to "L5A SA"
4. Union the output of the summarize with the pre-cross tabbed rows
Now when you cross tab, the "L5A SA" column will appear as a column and contain the sum of the values that exist in your input