Pivot table drill down

[#1]

Hi all,

i try to explain my problem:

My data consist of a hierarchy:  AREA -> FCS -> KPI -> Indicatore       (hierarchy is shown below in picture)

i want to create a pivot table like this:

the expression is not the same for all level of hierarchy because of the PESO (PESO in english means "weight") that change for each level, so the column where is insert the expression must change dinamycally in base of deep of the drill down/up. I mean: first case

the expression must be multiply for PESO of AREA_ID

second case:

the expression must be multiply for PESO of FCS_ID

third case:

the expression must be multiply for PESO of KPI_ID

and so on...

any suggestion?

THX

[#2]

i think i need a function like getselectedcount()>0 that told me when user click on plus of the table so i can condition the formula in expression... any suggestion?