Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?