Sum in pivot table with multiple dimensions

[Roberto03]

hi, 

i have a pivot table with 3 dimensions (AREA,Denominazione,DATA_CALENDARIO).

As you can see in the first row (first dimensione total) now there is the min (-100) of the below levels

this is the current function

if(dimensionality() = 1,
min( total <AREA,Denominazione,DATA_CALENDARIO> Aggr(

SOGLIAKPI_E - rangesum(above(total COUNT( DISTINCT {<RANGEABILITY_ANOMALIA_SNAM={'1'}>} HTM_DATA_CAMPIONAMENTO)/4/24, 0, rowno()))

, AREA,Denominazione, (DATA_CALENDARIO, (Ascending))))
,
if(dimensionality() = 2,
min( total <Denominazione,DATA_CALENDARIO> Aggr(
SOGLIAKPI_E - rangesum(above(total COUNT( DISTINCT {<RANGEABILITY_ANOMALIA_SNAM={'1'}>} HTM_DATA_CAMPIONAMENTO)/4/24, 0, rowno()))
, Denominazione, (DATA_CALENDARIO, (Ascending))))
,if( dimensionality()= 3,
SOGLIAKPI_E - rangesum(above(total COUNT( DISTINCT {<RANGEABILITY_ANOMALIA_SNAM={'1'}>} HTM_DATA_CAMPIONAMENTO)/4/24, 0, rowno()))
))
)

hovewer, in the first row I would like to add the total of the second levels if these are lower than zero (-13,-20-100)

thanks

Roberto