Creating pivot is possible ?

[sathyaKPMG]

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.

[caltang]

No, you will not get three rows worth of headers when you pivot. You will need to concatenate the fields so that the names are unique, then you can get your desired measures.

[sathyaKPMG]

Under the aging buckets i have 4 fields with different days period while converting that in excel i need to see the separate sum amounts for each days period .Is that possible .I attachement i have added created by excel .Not no need to create 3 rows just 2 rows.

[caltang]

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. 

[Qiu]

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

[sathyaKPMG]

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?