topic Re: Summarise and cross tab - Single Line Output in Alteryx Designer Desktop Discussions

Summarise and cross tab - Single Line Output

Akshay_Dakalia — Sun, 15 Mar 2026 05:07:59 GMT

Hi Community - In the sample excel, I have a few lines of the same invoice. I want to summarise it together into a single line with the Tax Rate as SGST and CGST coming under two columns. I tried using summarise and cross tab, but it is coming into two lines instead of one. Can someone please help?

Re: Summarise and cross tab - Single Line Output

OTrieger — Sun, 15 Mar 2026 07:58:13 GMT

@Akshay_Dakalia
Please share a print screen on how the data is looking in Alteryx the 2 lines that you are referring to, and a print screen on how you would like to have the data.

Re: Summarise and cross tab - Single Line Output

Akshay_Dakalia — Sun, 15 Mar 2026 10:04:10 GMT

Thanks for checking this for me.

Please find enclosed the snips as requested. Please let me know if you need anything else.

Re: Summarise and cross tab - Single Line Output

Qiu — Sun, 15 Mar 2026 23:31:56 GMT

@Akshay_Dakalia
I feel it might be something like this, but can not be sure.
Hope you check this one and fine it useful.