how to get total row in cross tab tool to title row as total

[Ksisterhen]

Hi-

Looking to find out how I can rename the total row the cross tab tool creates to total not null.

record 11 is the total tab the cross tab tool inserted and i am wanting to rename

[martinding]

Hi @Ksisterhen,

You could try this approach:

[Ksisterhen]

the column I am looking to add the total title too has another row that is null and i don't want that row to change to say title, just a specific null in row 11

[martinding]

Hi @Ksisterhen,

You could filter that null row first before adding the Total Title, and after that, union the row back.

[danilang]

Hi @Ksisterhen 

Assuming you're starting with the output of the crosstab, you can use the follow approach

Add a record ID and sort on RecordID descending.  Sample the first row and add a title. Union this with the remaining records and sort by RecordID asc. 

BTW.  What version of Alteryx are you using?  Newer versions add the "Total" row header automatically.

Dan 

[oliverchadwick]

I had the same problem and when I turned off AMP it worked correctly.