Cross Tab Tool Needs Static Headings Sometimes Data Changes

[chsteven]

I am working on a workflow that involves a crosstab tool. I have three categories I want as my headers, 1) Future Start - Open 2) Past Start - Closed 3) Past Start - Open.

I have found that week to week, my data changes and I may or may not have all three status categories in my data, when I perform the cross-tabulation exercise, I then have a column missing and my formulas and calculations down the line break as all three status columns no longer exist. 

What can I do to keep my three static columns and if I don't have data for one, have it show as 0?

[Luke_C · Accepted solution]

Hi @chsteven 

Here's a high level example that you can adapt. Keep the headers you need static in a text input and union it to the dataset. Then a multi-field formula can update null values. 

[chsteven]

This worked great, thank you!