Crosstab keep field heading?

[BosKev]

Is there a way to keep the field heading when doing a cross tab?

I want the field heading "ProductCount" to show as a row heading when cross tab to row. Thanks

ProductCount 

4269

4545

4859

[atcodedog05]

Hi @BosKev 

I am guessing you are looking at something like below.

Workflow:

Hope this helps : )

[BosKev]

@atcodedog05 , sorry wasn't clearer, I want the field heading "ProductCount" to replace the "1" under record(but remove the record heading, so I can tell what those number represent. But keep the month going across on top because its a trend.

[danilang]

Hi @BosKev 

The Record field that you see in a result window isn't a real field.   It's only put there by Designer to distinguish the rows and is always sequential.   On the plus side since it's not a real field it also doesn't show up in any output data.  

If you want to have a row header that you can manipulate, you need to add it as a real field into your dataset to Group By in the crosstab. 

After the crosstab, the results look like this

Dan