Subtotal of each section of data given in a column.

[shivama429]

Hello All,

I have been provided with a data wherein I have zones(north, south, east and west) in one column and in another columns I have states falling under each zone and in 3rd column I have numeric data for each state, now I need to insert a row every after the zone which to reflect total of each zone.

Can someone please help!!

[mbarone]

I would summarize (group by, sum) then join back to the original feed.

[echuong1]

The easiest way to achieve this is by using a summarize to get the total for each zone. I used a formula to add in a label for the state field - I made it "zz_Total" so that I could use this later on to sort by the state field and always have the total as the last row. I then used a union to append the original data and the total together, and a sort to get the correct order. I then used a formula to remove the "zz_" from the total label.

[shivama429]

Consider this as a scenario and every after a zone I need to add a row which will sumup the amount collected by each zone

[echuong1]

Updated with your sample data. Hope this helps!

[shivama429]

HI, 

Thank you for your help, just one more help....

Is it possible that instead of "Total" text can it come as a combination of Zone and then Total. For eg. for total of East zone text should be written as East_Total.

And instead of using Select tool to do it manually, is there a way to do it with some formula or tool?

Regards,

Shivam Arora

[pedrodrfaria]

Hi @shivama429 

I have attached the example above with the additional help you were looking for. You can use the Formula Tool to create string functions and create these fields with the desired names.

Pedro.