Calculate Averages per Different Levels

[#1]

I have a source file with these columns:

Person, Process, Sub-process, Item, Hours.

Process has multiple Sub-processes and Sub-process has multiple Items.

I would need to show Average hours a Person spent on each level. (with the drill down capability if possible).

I am using this expression: SUM(Hours)/Count (DISTINCT Process)

but need to be able to change it dynamically ...say if I select Sub-process or Item.

What would be a best way of doing this. (Chart or a table) and how?

[vishsaggi · Accepted solution]

Try this? Attached.