I need a simple way to group and summarize data at two levels.

Question

I have Risk Area- BU- Risk Factor and multiple levels of each. And I want to show the average risk rating and average controls rating for each Risk Area, and Business Unit.

Is there a quick formula that would show the average for each risk and bu?

What would be the best way to approach this? I would like to have the average risk appear on the master table as I use that to connect to Tableau for some nice visualization.

I just want to show the average at each level.

MJ215 · Answer

I think I want this to be in one table because the data feeds a tableau dashboard.

Andrée Starå · Answer

Hi @MJ215

I hope you're well and safe!

Have you explored using a report instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!