I need a simple way to group and summarize data at two levels.
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.
Help Article Resources
Check out the Formula Handbook template!