Messing around with a Hierarchy

[Anonymous]

Hi,

i've got this table:

Work Center	Attendance	Output
Workcenter 1	60	5000
Workcenter 2	40	8000
Workcenter 3	38	7000
Workcenter 4	123	1300

What i want to implement: When a user clicks on 'Workcenter 1', it should select all attendance Values but only '5000' from the output column.

Can somebody help me? Can i do this with a flag?

[jonathandienst]

In a straight table with dimension [Work Centre], use the following expressions:

     Sum(TOTAL Attendance)

     Sum(Output)

[Anonymous]

Jonathan,

this would work, but in most cases all attendance and all output values are needed.

let me know if my question is a bit unclear.

Edit:
What i want to accomplish:

KPI = Output / Attendance

In some WorkCenter groups this formula is a bit modified.

Lets say we've got the Workcenter "Electroplating". This Workcenter has some subgroups.
But for this formula its not:

Output from all subgroups / Attendance from all subgroups

but instead it is:

Output from one subgroup / Attendance from all subgroups    

I hope this makes it clearer