Summarize at different levels

[jay_viz]

I am trying to get % weight of a measure at different levels.

Dataset I am dealing with is county within each state and their revenue across different months. I have managed to get % weight for each county within the State regardless of the month. I am also trying to get %weight for each county for each month.. e.g. if NYC1 country has 400 in Jan & 600 in Feb then I am trying to get 40% and 60%.

I am not aware of a method how can I have 2 levels of summary like this which will finally give two different %weights. Attached workflow has %weight by county within the state and I am trying to get another column which is %weight for country by month. Thanks in advance.

[Qiu]

@jay_viz 
can you also share the input file if you could?

[jay_viz]

Sure, here is the file I have used

[Qiu · Accepted solution]

@jay_viz 
Thank you for providing the input file.
I basically followed your appoach, add one field Group by County in the summarize tool.
I also added Record ID for the input file for joining later.

[grazitti_sapna]

Hi @jay_viz, here is the sample workflow to the problem statement you described.

Thanks!

[jay_viz]

@grazitti_sapna Thanks, I think I was looking for a slight tweak in this solution where a county should add upto 100% when considering % by Month.. e.g OH2 should be added to 100% across month 1&2.

[grazitti_sapna · Accepted solution]

@jay_viz, in that case, you have to summarize separately on the basis of the county. In the screenshot, as you can see OH2 for Months 1 and 2 add up to 100% as required. Attaching the workflow.

Thanks!