Creating pivot is possible ?

Question

I have need the pivot in the format which has added in the attachment is that possible ? I have tried by using cross tab and Table but the result is not as what we are expecting .Is that possible to get the result similar to i have added in attachment.

Agingbucket.PNG

sathyaKPMG · Answer

Can you share the screenshots of the how the cross tab and table has been setup. And if that possible can you drop the workflow here?

Qiu · Answer

@sathyaKPMG 
You can try with the Pivot Funtion in Table tool, that would be our last resort.

caltang · Answer

The concept is the same - you now have 2 column headers, but only 1 exists in Alteryx.

You will still need to concatenate the column headers so that they are useable in Alteryx.