Summarize at different levels

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.

Summarize at diff levels.yxmd

Preparation

Accepted answers

Qiu

@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.

Summarize at diff levels-r1.yxzp

grazitti_sapna

@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!

jay_viz_workflow_updated.yxmd

All comments

Qiu

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

jay_viz

Sure, here is the file I have used

Summary by diff evels.xlsx

Qiu

@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.

Summarize at diff levels-r1.yxzp

grazitti_sapna

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

Thanks!

jay_viz_workflow.yxmd

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.

Quick Links

This months top contributors

mceleavey 382

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262