Crosstab keep field heading?

Question

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

danilang · Answer

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

ProductCountAsRowHeader.yxmd

BosKev · Answer

@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.

atcodedog05 · Answer

Hi @BosKev

I am guessing you are looking at something like below.

Workflow:

Hope this helps : )

ProductCount.yxmd