Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Adding Subtotal in Alteryx

PoojaNallawade
5 - Atom

Hi Team,

 

I want to add subtotal in file with the help of Alteryx.

 

Below is the final output which I required.

 

Thanks in advance!

 

 

 

2 REPLIES 2
cjaneczko
13 - Pulsar

Its possible to create the rows you are looking for but I am not aware of a way to create the "groupings" in excel. You wouldnt be able to collapse the rows. But to get the subtotals. you would branch your data off with a summarize tool grouped on your Composite, and sum on Market Value and % of Net Assets. Then add a formula tool which will be [Composite] + " Total" to add the word total after the Composite number. Union that data back into your main workflow. Then add a Sort tool on the Composite field. This will insert the summarize rows after each group of composite numbers. 

PoojaNallawade
5 - Atom

Hi,

 

Thank you for your assistance, I tired doing it and have got attached output but I am getting sum of Market value in another column.

 

Thank You!